Below is a copy of the code for passing the return code from oracle to unix. There are two input parameters and an out parameter in our procedure which we are trying to pass to the num variable in UNIX.

Help! An error is given upon execution

typeset num

num=`sqlplus -s < ${USER}/${PASSWD}
exec update_status($3,'sending',num);

EOSQL
`