OUT Parameter not returning from Package to Shell Script
Hi/Hello All,
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
I am having the shell script block (.sh file) which will call the Package and insert the data. If the data resulted in error then retcode should pass 2 from the package. But the value is not returning back to the shell script.
Tried adding an additional parameter for OUT in package to pass that value and still no use. IN parameters are working fine from Shell to Package.
Appreciate your kind assistance.
Thanks
sqlplus -s $LOGIN@$SID <<+ >> $OUT_DIR/$OUTS_FILE
SET VERIFY OFF
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;