alter procedure "TEMP"
Returns ( "ERROR" VARCHAR (100))
as
declare variable s int;
begin
begin

exception EXIT_;
s = 5/0;

when exception EXIT_
do begin
error = 'Exit';
end

when exception
do begin
error = 'AO';
end

end
suspend;
end

when I do select * from temp I get 'AO' not 'EXIT'. Shouldn't Exit be trapped first?


Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz