A bizarre situation - SQL query finds no records when record is present.

Thanks for your reply.

There is one misunderstanding here, however.

The delete/reinsert cycles are not something that is happening concurrently with reads. They are essentially part of a "commissioning" process for the database (and app), so during the commissioning process the app is not running (and hence there is no reading).

We can also run another delete/reinsert cycle, but that would be done under the same conditions of not having the app running at the time (ie. during a declared maintenance window).

So I don't really understand how the cursor's "internal working set" can fail to see the record.