I am calling a sqlplus script to run from the linux at the command prompt. $ .test.sh

It runs the sql script but does not exit sqlplus as it is waiting for the quit command.

When called from cron thru crontab, all the sql scripts run fine and do not require the quit command to come out of sqlplus.

How do i get around this, or why is this different?

Please post the script.

#!/bin/bash

# CHANGE LOG
# 02-23-05, Steve Brown, created to use for testing batch schedule.
# mm-dd-yy, Name, what and why.

# SET DEFAULT ENVIRONMENT
. $HOME/.bash_profile

# CHANGE TO WORKING DIRECTORY
cd $HOME/scripts

# REMOVE TEMPORARY FILES
rm -f reid_test.out

# START
echo "********** SCHEDULE START **********, $(date +"%D %T")" > reid_test.out
echo "" >> reid_test.out
echo "RUN SHELL 1, start, $(date +"%D %T")" >> reid_test.out
sqlplus -s xxx/xxx @reid_test.sql > reid_test.sql.out
cat reid_test.sql.out >> reid_test.out
echo "RUN SHELL 1, end, $(date +"%D %T")" >> reid_test.out
echo "" >> reid_test.out
echo "" >> reid_test.out
echo "RUN SHELL 2, start, $(date +"%D %T")" >> reid_test.out
. reid_test2.sh
cat reid_test2.out >> reid_test.out
echo "RUN SHELL 2, end, $(date +"%D %T")" >> reid_test.out
echo "" >> reid_test.out
echo "********** SCHEDULE END **********, $(date +"%D %T")" >> reid_test.out

# EMAIL RESULTS
mail -s "BATCH SCHEDULE JOB RESULTS" xyz@xxx.com < reid_test.out