Re: COMMIT in for loop

In article <376AA2B5.B5A1CED5_at_lucent.com>,   Kenneth C Stahl <kstahl_at_lucent.com> wrote:
> It may be a rollback segment problem.

You must be right because when I try it again I get:

ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 8 with name "RBSLRG07" too
small

 What version of the RDBMS are you
> working with?
>

7.3.3.6. They are planning to go to 7.3.4 real soon.

> 1. Make sure that you have a rollback segment that has an OPTIMAL size
> set

How can I determine this?
> 2. 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

Thanks for your help!
>
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 21 1999 - 09:24:43 CDT