Re: COMMIT in for loop

From: Dogan Cibiceli <dcib_at_gwl.com>
Date: Tue, 22 Jun 1999 15:12:15 -0600
Message-ID: <376FFC2F.E77A74DC@gwl.com>

amyleone_at_my-deja.com wrote:

> I am getting an Oracle internal error when doing a COMMIT
> inside a FOR loop in my PL/SQL procedure. Are you not
> allowed to do that? It was working before, in fact it
> works for about 200000 rows before it crashes. Thanks
> for any help you can give.
>
> Amy
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Try commiting fewer commit not every row but every few hundred row. Is the error (rollback | snapshot) ( too old | to small) ? 1555 if I remember correctly ?

D Received on Tue Jun 22 1999 - 16:12:15 CDT