Hi, I need help again. When I run this shell script, it only runs the unld_date.sql piece and exits. How can I structure this to run all the way to the end? When I don't have the unld_date.sql piece in here, everything runs fine from the date compare piece all the way to the end. Thanks in advance.


#!/bin/sh
#
sqlplus -s <<EOF username/password @/dir1/unld_date.sql > /dir2/dt_file.dat
exit 0
#
dt=`cat dt_file.dat`
today_dt=`date +%m%d%Y`
if [ "$dt" = "$today_dt" ]
then
#
# run pl/sql procedures 1 and 2
sqlplus -s <<EOF username/username @/dir3/code1.prc > /dir4/code1.log
@/dir3/code2.prc > /dir4/code2.log
exit
EOF
#
tail -10 /dir4/code1.log > log1.txt
tail -10 /dir4/code2.log > log2.txt
#
exit

If this is really how your script reads, the "exit 0" is going to terminate your script every single time once "unld_date.sql" has been executed.

If it is working with "unld_date.sql" removed then you must also be removing "exit 0". The "exit 0" statement is not tied to the sqlplus command.

So the simple answer to your question is to remove "exit 0".

I have taken out the "exit 0" line and it still gives me the same result. It stops right after the unld_date.sql and doesn't execute the rest. Thanks.

where you have the exit 0, try putting EOF. Im a newb, but I think when you use <<EOF it expects anything between that and EOF to be commands within the program you started before the <<EOF.

I agree.
I think your script should read:
Though it seems incomplete... I miss a "fi" and there are also an "exit" that, in my opinion, does not fit (the last one)...

Regards.

Looking at the script again, the answer is clear. You are attempting to use a "here" document with the "<<EOF" statement. Your entire script is being pushed into sqlplus and when it reaches the "exit 0" command, it is exiting and the rest of your script isn't processed by sqlplus, which is why you don't see any error in you code1.log file.

You either need to add the "EOF" as stated by other posters or remove the "<<EOF". sqlplus will run the SQL at this point and let your script continue.