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