I have been running a function in Oracle that works fine. When I try to extract the return code to a variable called num in UNIX the variable never gets set to the return code from Oracle. The code I am using is below. I welcome any ideas or comments. Thanks
num=`sqlplus -s << EOSQL
set serveroutput on
x := UPD_FUNC(000046,'E');
Try putting a slash after the end; in your pl/sql block. I tried this and it worked. However it also displays PL/SQL procedure
successfully completed as output. I don't know how to suppress that.