Shell Programming and Scripting

Hi,
I am a newbie and was getting an error when I use the if..else syntax. The script looks like this

echo "Please specify the database version (9i/10g): "
read VERS
if [ "$VERS"="9i" ]
then
echo "Its a 9i Database"
sqlplus -s $puser/$ppass << EOF_I
spool cxcreate9i.lst
@ cxtool/1.1/scripts/backend/cxcreate;
spool off
exit;
EOF_I
else
echo "Its a 10g Database"
fi


Now when I execute it I get the following error:
./test.sh: line 17: syntax error: unexpected end of file

If I remove the if else syntax and just put the middle portion in the script, it executes fine.

sqlplus -s $puser/$ppass << EOF_I
spool cxcreate9i.lst
@ cxtool/1.1/scripts/backend/cxcreate;
spool off
exit;
EOF_I

I am not able to understand what am I doing wrong here.

Thanks

Are you indenting the code between "sqlplus" and "EOF_I" in some way?

The closing "EOF_I" clause MUST be at the beginning of the line (no white spaces before).
Also, you may remove the space between "<<" and "EOF_I", or try:

Code:

echo "Please specify the database version (9i/10g): "
read VERS
if [ "$VERS"="9i" ]
then
   echo "Its a 9i Database"
   sqlplus -s $puser/$ppass <<-EOF_I
   spool cxcreate9i.lst
   @cxtool/1.1/scripts/backend/cxcreate;
   spool off
   exit;
EOF_I
else
   echo "Its a 10g Database"
fi

Not sure what is going wrong, but just try this:

Code:

echo "Please specify the database version (9i/10g): "
read VERS
if [[ "$VERS" = "9i" ]]; then
echo "Its a 9i Database"
sqlplus -s  $puser/$ppass << EOF
spool cxcreate9i.lst
@ cxtool/1.1/scripts/backend/cxcreate;
spool off
exit;
EOF
else
echo "Its a 10g Database"
fi

Oh shoot...you got it right on...I was using one of the editors which looked nice with indented code. It works if i remove the indents.

Thanks a million robotronic..