I have a short Pro*C program to remove unwanted rows from a table. The
program consists of a cursor, a main loop, a fetch, a delete, and a
commit ever 100 rows (I've also tried 1, and 1000 rows). At some random
seeming point during the execution of the program, I get a -1555 returned
in sqlca from the fetch. I'm at a total loss on this. I have gotten
around it, for now, by closing the cursor, reopening it, and continuing
the loop when I encounter this, but this can't be right.
The oracle support guy sent me an email that relates to rollback segments.
I completely rebuilt the 120 MB of rollback segments to no avail. There
is no-one else but me using the table. The table originally started out
as an import of a customer's 8.8 million rows. I have used the same
program with a different cursor to remove 3.3 million rows with no
problems. I have other criteria that need to be applied to the table
now to get it chopped down to what I need to send back to the customer.
Any thoughts?
TIA.
--
Bob Stewart ASE
(310) 335-7152 (USA) Air Transport Systems
bob_at_latcost1.alaao.ats.eds.com
The opinions expressed above are my own, and may not
represent those of my employer.