how to execute a stored procedure with an out value in a shell prog
Posted on 2006-06-26
I am trying to execute an oracle stored procedure in a shell script and then using the exit value from the procedure in a IF condition in the shell script. The out parameter is a number, its a s follows, the procedure is called within check_4_data.sql but is giving me the following error "SP2-0734: unknown command beginning "PDL.FIND_D..." - rest of line ignored. SP2-0103: Nothing in SQL buffer to run."
checkdatapdl=`sqlplus -s $conpdl @$DIR/check_4_data.sql &`
echo $checkdatapdl >> $LOG
if [$checkdatapdl = 1] ; then
echo "EXISTEN DATOS" >> $LOG
echo "No EXISTEN DATOS" >> $LOG