Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP

[Christophe Pettus]

> On Oct 18, 2022, at 13:14, Ravi Krishna <s_ravikris...@aol.com> wrote:
> 
> I am getting error at COMMIT -> cannot commit while a subtransaction is 
> active.
> Is commit not possible in a loop

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.