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