Shell Programming and Scripting

 
dbSID="SWQE"
usrname="apps"
password="Wrgthrk3"
count=0
while [ $count -lt 3 ]
do
    sqlplus $usrname/$password@$dbSID <<-EOF 
    WHENEVER OSERROR EXIT 9;
    WHENEVER SQLERROR EXIT SQL.SQLCODE;
    prompt Connected to the database;
    quit;
    EOF
  count=`expr $count + 1`
done

do
    sqlplus $usrname/$password@$dbSID <<-EOF 
    WHENEVER OSERROR EXIT 9;
    WHENEVER SQLERROR EXIT SQL.SQLCODE;
    prompt Connected to the database;
    quit;
EOF  -------------NOTE: This should start at the very beginning!!

dbSID="SWQE"
usrname="apps"
password="Wrgthrk3"
count=0
while [ $count -lt 3 ]
do
    sqlplus $usrname/$password@$dbSID <<-EOF 
    WHENEVER OSERROR EXIT 9;
    WHENEVER SQLERROR EXIT SQL.SQLCODE;
    prompt Connected to the database;
    quit;
EOF======================> i kept EOF without any space before i,e at the starting of the line and it worked.
  count=`expr $count + 1`
done