Re: CURSORS AND ROLLBACK SEGMENTS: which one is correct ?

From: Dogan Cibiceli <dcib_at_gwl.com>
Date: Tue, 06 Apr 1999 15:28:20 -0600
Message-ID: <370A7C74.4742EDEC@gwl.com>

jgopinath_at_gt.com wrote:

> Hi, I have a CURSOR which selects around 30,000 rows. I then process the rows
> returned by the CURSOR. After processing each row, I do a commit. THe stored
> procedure seems to process around 10,000 rows and then throws up an error
> saying that the rollback segment is too small. No other errors are generated
> by the procedure. My understanding was that if we do a commit after each row
> is processed, there is no reason for the rollback segment to be filled. Am I
> missing something here?? ANy help would be appreciated. Thank You, rgds
> Jayadev
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

I have the same problem and I am not updating any row that I havenot touched yet. I am querying and updating the same table. So what is the proper answer ?

Dogan Received on Tue Apr 06 1999 - 16:28:20 CDT