Store return value from the procedure into shell variable
961913Sep 24 2012 — edited Sep 25 2012Hi Gurus,
I am trying to store the OUT Parameter return value from the procedure into shell variable as below;
RET_VAL=`sqlplus $DB_USER/$DB_PASS << EOT| egrep . > $SCRIPT.tmp
set linesize 2500 pagesize 0 echo off heading off feedback off verify off
VARIABLE line VARCHAR2(4000)
exec UPCStreamDiffNodeVersions($MStreamName,$oldVersion,$newVersion,:line);
print line;
EOT`
echo $RET_VAL
i can print whats in the variable line but cannot get into the $RET_VAL. Kindly suggest.
Regards
Rajan