Hi, I need your help. When 2 users want to edit a table using 6i forms, oracle makes a deadlock, but the users are editing different row. The same happens if one user edits a table and another user “select” on the same table. I am using oracle 11g xe. I hope you can help me. thanks.
Share
In Oracle Forms 6i, you will find a property for the data block named Locking Mode. It is default set to Automatic. You can test by changing the property to a Pessimistic type.