Re: PL/SQL: exception handling

From: Lee Levy <levy.lee.ls_at_bhp.com.au>
Date: 1996/03/01
Message-ID: <4h5k9l$725_at_gossamer.itmel.bhp.com.au>#1/1


In article <3134a69b.935153_at_nntp.ix.netcom.com>, chuckh_at_ix.netcom.com (Chuck Hamilton) says:
>
>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.
I think gary meant on each sub-block, something like the following: procedure <procname> is
  procedure handle_exception is
  begin
    (stuff...)
  end
begin
  begin

  • block 1 code exception when others then handle_exception end; begin
  • block 2 code exception when others then handle_exception end; begin
  • block 3 code exception when others then handle_exception end; begin
  • block 4 code exception when others then handle_exception end; begin
  • block 5 code exception when others then handle_exception end; end;

Does that help?
Lee

------/\/\------+---------------------------------------------------
     / / /\     |  Lee Levy, ISSD Systems Development, Del Code (34)
    / / /  \    |  BHP Information Technology,  ACN 006 476 213
   / / / /\ \   |  PO Box 261, Warrawong, NSW 2502, Australia
   \ \/ / / / | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-     \ / / / | Internet : levy.lee.ls_at_bhp.com.au
-----\/\/\/-----+---------------------------------------------------
Opinions expressed are mostly my own, so give me some credit. Received on Fri Mar 01 1996 - 00:00:00 CET

Original text of this message