Re: COMMIT in for loop

Thanks, I did implement this suggestion but this just brought me back to the Oracle internal error instead of the rollback segment error (I guess that's progress). Now the DBA says it is due to an invalid index structure. So hopefully he can fix that. Thanks for all your advice.

Amy

 In article <37701500.92284DC7_at_exesolutions.com>,   "Daniel A. Morgan" <dmorgan_at_exesolutions.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.
>
> There is no problem commiting inside of a loop with Oracle with the
> exception of using dynamic sql. Not that it shouldn't work but with
some
> versions it does what you describe. I would institute a counter and
commit
> either more frequently or less frequently. Another alternative is to
add a
> where clause to your cursor and perform the actions in several
different
> loops rather than just one. First loop handles values between A.. and
H..,
> second loop values between I.. and P.., etc.
>
> Daniel A. Morgan
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 23 1999 - 07:22:06 CDT