hi,

i am trying to connect to sqlplus in an 'if block' from the script.
it is giving unexpected end of file error.
and it works fine if it is out of 'if block'.

if anybody have idea on this, can you please help me to solve the error ?

piece of code is given below.

if [ 0 -eq $(ls verify_inbound_failed.txt | wc -l) ]
then
sqlplus -s /nolog <<EOF
connect $db_username/$db_password@$db_sid
exec pr_od_lp_override();
exit
EOF
fi

Thanks in advance
Vinay

Did you use a dos/windows editor?

here am using Textpad.
is it going to differ by editors?
its urgent,, can you pls help me,,,,

Dos/windows editors add a CR at the end of the line, remove them with:

tr -d '\n' < file > newfile
mv newfile file

here the problem is , same code works fine with no error if it is not there in "if" block. as i have shown above.

Have you removed the CRs from your file?

Have tou tried this ???

if [ 0 -eq $(ls verify_inbound_failed.txt | wc -l) ]
then
sqlplus -s /nolog <<EOF
connect $db_username/$db_password@$db_sid
exec pr_od_lp_override();
exit
fi
EOF