Re: Exception Handling in PL/SQL
Date: Wed, 2 Dec 1992 20:39:16 GMT
Message-ID: <1992Dec2.123916.1_at_us.oracle.com>
In article <By8KBI.HM2_at_inews.Intel.COM>, kortikar_at_mipos2.intel.com (Aniruddha Kortikar) writes:
>
> declare
> e1 EXCEPTION;
> begin
> declare
> e1 EXCEPTION;
> begin
> .....
> ....
> raise e1;
> end;
> exception
> when e1 then
> .....
> 1. since inner block has no handler for e1 what happens to 'raise e1' ?
> manual states the inner e1, and outer e1 are different.
They are two different exceptions with different scopes. In the above
example, you would should get an unhandled user-define exception.
>
> 2. if one writes 'when e1 ...' code in inner block will it handle e1.
> manual stated use when others could be used, or declare only 1 e1.
>
Yes you can have a when e1 within the inner block.
Radhakrishna Hari
rhari_at_us.oracle.com
Received on Wed Dec 02 1992 - 21:39:16 CET