Re: COMMIT in for loop

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Fri, 18 Jun 1999 15:49:09 -0400
Message-ID: <376AA2B5.B5A1CED5@lucent.com>

It may be a rollback segment problem. What version of the RDBMS are you working with?

Make sure that you have a rollback segment that has an OPTIMAL size set
Make sure you use that rollback segment by SET TRANSACTION USE ROLLBACK SEGMENT xx;

Also, make sure that your commit encompasses an entire transaction - that way if an error occurs you won't end up with a partial transaction.

Ken

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.
Received on Fri Jun 18 1999 - 14:49:09 CDT