I am having an issue where I have a Data reader which contains the records to
process and I loop thru this data reader until all rows are processed.
Within that loop, I have a call to an Oracle stored procedure which, among
other things, deletes the row which is being used by the data reader. I
have ensured that the update process is performing a commit after the update.
When all of the data reader records are processed, the process loops back
and re-executes the data reader, as additional records could have been
created in my update process (within the loop described above). Every time I
re-execute the code to re-populate the Datareader, I have exactly the same
number of records in that data reader as when I first started. It is acting
as if the commite was not functioning (but I know that this is not the case).
Why do the same records show up again in the datareader if they were deleted
within the looping process which processes that datareader?
Rather then looping through the records one by one, I changed the stored
procedure to do the looping stated above and call it in my program and it
works just fine. I was wanting to do it transaction by transaction, if I
could, but that process does not seem to see the updates which are made.
Any ideas?
Thanks in advance for your assistance!!!!