Exit from an Exception Block

I have a large number of pl/sql programs that all have exception blocks coded in them. I want to cause the programs to exit with a specific return code any time an exception is raised. Why doesn't the "exit 12" stmt work in the exception block. Also it seems that when you have an exception block the "whenever sqlerror exit nn" stmt does not work.

I can code an "exit 12" after each "raise" stmt but this doesn't catch the "Others" situations that have no specific raise stmt.

Thanks in advance for your help. Received on Tue Aug 11 1998 - 14:27:58 CDT