return code from unix

[marist89]

I would change update_status to a function. Then, I would use something like:

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