Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP

[Ravi Krishna]

> You can commit in a loop, but not in BEGIN / END block that has an exception 
> handler:> that creates a subtransaction for the duration of the BEGIN / END.
The reason I have to deal with error exception is that I want to ignore failure 
on a table and move on to next table. 
I thought I can trick it by moving the part of the code which executes dynamic 
sql and has exception handler in it,to a separate procedure.  This way I can 
keep the main procedure without exception handler.  It failed too withthe same 
error.  So that means this restriction is not at lexical level, but at 
execution level.This is so disappointing.  It seems there is no way I can copy 
each table and commit it individually and also capture error.