Shell Programming and Scripting

#!/bin/ksh
# Shell Type : Korn Shell

SetXMLClob()
{
	echo "Starting SetXMLClob function....."
	LOGID=$2
	FILENAME=$3
	PROCEDURE_NAME=$4
	LOGFILE=$1/Log/$PROCEDURE_NAME"_"$LOGID.log
	export LOGFILE
	VALUE=$(cat $FILENAME | sed -e ':a' -e 'N' -e '$!ba' -e 's/\n//g')	
	LENGTH=`expr length "$VALUE"`
	VALUE=`expr substr "$VALUE" 3 "$LENGTH"`
	echo $VALUE
	CHAR="'"
	while [ $LENGTH -gt 1 ];
	do
		SUBVALUE=`expr substr "$VALUE" 1 999`
		SUBLENGTH=`expr length "$SUBVALUE"`
		SUBVALUE=$CHAR$SUBVALUE$CHAR
		echo $SUBVALUE
		echo $LENGTH
		export SUBVALUE
		$1/spool_procedure.sh "$PROCEDURE_NAME" "'"$LOGID"'"
		
		if [ $SUBLENGTH -ge $LENGTH ]; then
			LENGTH=0
		else
			INDEX=`expr $SUBLENGTH + 1`
			VALUE=`expr substr "$VALUE" "$INDEX" "$LENGTH"`
			LENGTH=`expr length "$VALUE"`
		fi
	done
}

################################################### MAIN BODY
case $1"" in	
	"/SET") 	
		echo "----------------------" >> $LOGFILE
		SetXMLClob $2 $3 $4 $5;;
esac

PROC_NAME=$1
ROWID=$2

USER=$USERNAME
PASS=$PSW
CONNECTSTRING=$SID_ORACLE
#cd $LOCAL_CORE_FOLDE

echo ------------------------- >> $LOGFILE
echo Start: $DATESTAMP     >> $LOGFILE
echo LogId: $ROWID     >> $LOGFILE
# Now call the file spool sqlplus script 
( echo "CONN $USER/$PASS@$CONNECTSTRING"
  echo "EXEC $PROC_NAME("$ROWID","$SUBVALUE")"
  echo "EXIT"
) | sqlplus -s /NOLOG >> $LOGFILE

SUBVALUE=""
DATESTAMP_LOG=`date`
echo End: $DATESTAMP >> $LOGFILE

sqlldr $USERNAME/$PSW@$SID_ORACLE data=$CSV_FILE control=$1/NextdeCustLoad.ctl log=$1/Log/$LOGID.log bad=$1/bad/$LOGID.bad rows=10000;