Re: PL/SQL: exception handling

afischer_at_ea.com wrote:

>gapinski_at_lerc.nasa.gov (Gary Gapinski) wrote:
>>Hello, Chuck:
>>
>>An exception clause is needed in each block in order to catch any exception
>>therein. You can refer to a common exception handler procedure from within
>>each, if that makes life any easier. As long as you avoid raising another
>>exception from within the handler, the successive sub-blocks will be
>>executed.
>>
>>Regards,
>>
>>Gary
>>
>>--
>>__________________________________________________________
>>Gary Gapinski email: gapinski_at_lerc.nasa.gov
>>NASA Lewis Research Center voice: +1 216 433 5251
 

>>An exception clause is needed in each block in order to catch any exception
>>therein.
>
>Sub block exceptions propagate to the enclosing block's exception handlers, if no handler
>exists in the sub block for that exception (and no "when others").
>
Yes, but after the enclosing block's exception handler executes, it doesn't return control to the next statement after the sub-block, but rather the one after the enclosing block. I want it to do the opposite. If sub-block 1 traps an exception, I want it to continue to sub-block 2.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

If at first you don't succeed, skydiving isn't for you.