Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP

> On Oct 18, 2022, at 13:14, Ravi Krishna <s_ravikrishna@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
theduration of the BEGIN / END.