Shell Programming and Scripting

If I execute this script:

$ORACLE_HOME/bin/sqlplus -s <<EOF > oracle.log
$DB_id/$DB_pswd@$DB_server
start test.sql
EOF
the sql script executes with no errors.


IF I execute the following script:

UsedSpace=`df -k . | awk '{print $5 }'| tail -1 | cut -d"%" -f1`

if [ $UsedSpace -ge 50 ]
then
cd /ford/thishost/u/rct/www.80/crid/crid_new/cronjobs
$ORACLE_HOME/bin/sqlplus -s <<EOF > oracle.log
$DB_id/$DB_pswd@$DB_server
start test.sql
EOF
fi
I receive a syntax error. The syntax error must be the way I am wrapping the if clause because the line starting UsedSpace works fine. What am I doing wrong? Thanks for your help.

I have never seen the "Start" usage before. I would replace "start test.sql" with @test.sql (supply a path to the script if need be)

I have replace "start" with "@". I am still getting syntax errors. Is there anybody else that can help me?

What is the actual syntax error thrown? What is UsedSpace set to after this line is executed

Code:

UsedSpace=`df -k . | awk '{print $5 }'| tail -1 | cut -d"%" -f1`

Also (not that this will fix your issue but..) this would be cleaner syntax and it allows variables to be nested.

UsedSpace=$(df -k . | awk '{print $5 }'| tail -1 | cut -d"%" -f1)

$ORACLE_HOME/bin/sqlplus $DB_id/$DB_pswd@$DB_server <<EOF
.....
EOF

FWIW -
start comes the afi/ufi pre-Sqlplus versions of Oracle. It is exactly the same as @, just from version 2 of Oracle.

The value of this variable is 80. I have tried all suggestions, but I am still getting a syntax error.

test.sh: syntax error at line 34: `end of file' unexpected

Line 34 goes beyond the last line in file test.sh