Shell Programming and Scripting

Hi Folks.

My script is not exiting after run though its working correctly please suggest.

#!/bin/ksh
trap '' HUP

. /bin/functions
config_env
PATH=/bin:/usr/bin:/usr/local/bin:$EXEC_PATH:$ORACLE_HOME/bin
MONTH=$(control_register month)
YEAR=$(control_register year)
DATE_NOW="Job Started At $(date +'%Y/%m/%d %H:%M:%S')"
LOG_DIR=$LOG_PATH/$YEAR/$MONTH/refresh_backfeed
LOG_FILE=$LOG_DIR/refresh_backfeed.log
ORACLE_LOG_FILE=$LOG_DIR/IRISCOS_package.log
SQL_PACK="IRISCOS_REFRESH_pkg.IRISCOS"
if [[ ! -f $LOG_DIR/$LOG_FILE ]]
then
if [[ ! -d $LOG_DIR ]]
then
mkdir -p -m775 $LOG_DIR
print "creating $LOG_DIR" >>$LOG_FILE
fi
fi
echo " ${DATE_NOW} " > $LOG_FILE

# Run pack
run_sqlplus "exec $SQL_PACK "
EOF

DATE_NOW="$(date +'%Y/%m/%d %H:%M:%S')" >> $LOG_FILE
echo "job SUCCESS " >> $LOG_FILE
exit 0


After runing ./script_above runs the package not sure y its not exiting from the black screen need suggestions!

I can't say for sure what is wrong, but I can make a guess based on a suspicious construct in the script.

Given this
run_sqlplus "exec $SQL_PACK "
EOF

It seems possible to me that the sqlplus is running, and reading standard in.
Nothing will change until it gets a *real* EOF, not the string "EOF" on the next line.

My guess is that it should have and empty "here-is" document like this:

run_sqlplus "exec $SQL_PACK " << EOF
EOF

The shell handles the "<< EOF" and puts <nothing> into the file which it attaches
to stdin for the run_sqlplus command. run_sqlplus will get an immediate end-of-file
when it reads stdin, and with luck, will exit and return control back to the script.


Also, you will lose the message "creating <log_dir>" from the log file because
echo " ${DATE_NOW} " > $LOG_FILE
does not use ">>"