Shell Programming and Scripting

Code:

sqlLogftp_mov=$LOGDIR/logftp_mov_$mydate.log
sqlplus -s $ORAUSER << EOF > $sqlLogftp_mov
SET SERVEROUT ON
@/$SCRIPTDIR/rep_comm_ext_tbl_load.sql
EOF
retorno=0
cnt=`grep -q 'ORA-' $sqlLogftp_mov | wc -l`
if [ $cnt -gt 0 ]; 
then
retorno=1
echo 'Failure'
sendEmailFalha
exit 1
fi
if [ $retorno -eq 0 ];
then
echo 'Success' 
sendEmailSucesso 
exit 0 
fi

In the above shell script,I called a sql script.It worked super cool but the problem is
I couldn't use that grep,it throws the error.
"grep: 0652-033 Cannot open /sharedapps/etlusr/etl/logs/logftp_mov_03082010061856.log."
I think the control is not flowing back to shell after calling sql script.
Even I tried putting a " echo 'hi' " after the EOF in the above script,on running the script I am not getting the echo printed and only shows the above error.

Any help in this case will be very helpful..Thanks

If the other application still has it open, you might try to sleep just before grep:

Code:

sleep 1

But the grep command has a problem. The -q switch makes it quiet. Try this instead:

Code:

cnt=`grep -c 'ORA-' $sqlLogftp_mov`

Thanks for the quick reply.
I tried using sleep 1 grep -c but I am still getting the same error

---------- Post updated at 07:51 AM ---------- Previous update was at 06:21 AM ----------

There is no other application which is keeping it open;I am just thinking that after calling the script,the control is not flowing to shell.
Even the echo statement after EOF is not executing..

hi,

Code:

sqlplus -s $ORAUSER << EOF > $sqlLogftp_mov
SET SERVEROUT ON
@/$SCRIPTDIR/rep_comm_ext_tbl_load.sql
exit;
EOF

add "exit;" before EOF and try to execute the script

Hi Pravin,

I tried with exit; before EOF but it is still throwing the same error

what's the sql file doing? that's weird that you'd get a grep error prior to an echo..

grep: 0652-033 is a "file not found" error. Have you checked that /sharedapps/etlusr/etl/logs/logftp_mov_03082010061856.log exists? I don't know sql, is it creating the file with it's output? Maybe if there's no output, it's not creating it?