Database Administration (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center