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
Received on Fri Apr 02 1999 - 14:28:55 CST
