Exception Handling in PL/SQL

From: Aniruddha Kortikar <kortikar_at_mipos2.intel.com>
Date: 24 Nov 92 19:47:41 GMT
Message-ID: <By8KBI.HM2_at_inews.Intel.COM>


	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. 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.

Aniruddha Kortikar (kortikar_at_mipos2.intel.com)


E-mail 	: kortikar_at_mipos2.intel.com | A billion here, a billion there ...
Phone(W): 408 765 5515              | pretty soon it adds upto real money.
-------------------------------------------------------------------------------
Received on Tue Nov 24 1992 - 20:47:41 CET

Original text of this message