Re: COMMIT in for loop

From: Gerard M. Averill <e-mail.address_at_my.sig>
Date: Mon, 28 Jun 99 17:47:49 GMT
Message-ID: <7l8c4r$14jm$1@news.doit.wisc.edu>

In article <7kp6vm$5bd$2_at_eve.enteract.com>, Brett Neumeier <sacq_at_usa.net> wrote:
>amyleone_at_my-deja.com wrote:
>> 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
>
>The problem you are encountering is caused by fetching from a
>cursor after doing a commit. When you perform a commit, you
>should close and re-open all cursors. Oracle's problem report
>number 1005107.6 describes the situation rather completely.
>

<snip>

Brett,

If possible, could you point me (more directly) to that problem report. I searched the problem reports at Oracle's site but could not seem to find it. Thanks.

Gerard

---

Gerard M. Averill, Researcher
CHSRA, University of Wisconsin - Madison GAverill<at>chsra<dot>wisc<dot>edu Received on Mon Jun 28 1999 - 12:47:49 CDT