Hi,
Currently I'm using Oracle Forms 10gR2.
My problem is that after when users use the system for a while, doing a lot of insert , delete , update .. ( of course they commit all of that), the Isolation level randomly changes to Seriablizable, despite the fact that I already set Isolation Mode to Read Commit. Therefore, in their next transactions, Ora-08177 will randomly be displayed, the only solution is re-logon into the system again. After re-logon, they are free from Ora-08177 for first several transactions and the problems go on. This only happens in Oracle Forms, and after transactions with many rows updated, deleted, or inserted.
So I'm wondering if there's any way to force Forms to use Read Commit level or restrict Seriablizable ?
Thank you very much.