sqlplus Setting the exit code of a script

How can I set the exit code of a script?

The following doesn't seem to work

WHENEVER SQLERROR EXIT 5

DECLARE
     retCode number := 0;

BEGIN
     retCode := 30; 
END;
/
EXIT :retCode ;

Gives the usage for EXIT with an exit code of 1

Try it like this:

var retCode number
exec :retCode := 30;
exit :retCode

(See http://www.orafaq.com/forum/mv/msg/80574/233106/0/#msg_233106)

Bottom line is that retCode must be a variable defined in SQLPLUS's scope. Your DECLARE is inside a code block, and SQLPLUS can't see into it.

StackExchange Database Administrators Q#3288, answer score: 5