Re: Exception Handling in PL/SQL

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