SQL & PL/SQL

Hi,

I searched the forum, but I didn't found anything related to my problem with ORA-08006:
I have a global temporary table WDOCS (on commit preserve rows).
The application logic (called from one DB session) is something like this:
1. cal PL/SQL procedure GENERATE_WDOCS - which generates data to WDOCS
2. COMMIT
3. SELECT rowid from WDOCS
4. UPDATE WDOCS SET column1 = 'ABC' WHERE rowid = returned from step 3.

Users get error messages in the application and in the log file I found

ORA-08006: specified row no longer exists

which is raised after UPDATE - step 4.

I'm not able to reproduce the problem, the error occurs maybe 1 per week on the production system where a lot of users (>50) are working on the same procedure described above.
I tried several cases to reproduce the problem without success.

Any idea?

Thanks, Smilca