Re: Snapshot too old

Hi Faizel,

that a well known problem concerning cursors. An open cursor holds its data in a snapshot. If you change its data in the database with a commit, the next fetch raises the error.

Skip the commit within the loop
or
if you cannot, close the cursor, commit changes and reopen cursor, minor problem with the cursor positioning.

---
Dieter