Hi all,

If I have code something like:

begin
insert into mytable values ('a');
execute procedure xx; /* xx might throw exception */
when any do
begin
...
end
end!!

and sproc 'xx' does throw an exception, will it automatically undo
actions performed in 'xx' even though the exception is being handled
one block up?

Would it undo the 'insert...'?

Thanks,

John