Locking problem

[Michael Doel]

In PLSQL Developer version 6.0.3.893 we encountered a problem when updating a record in the database (Oracle 9.2 Linux):
When posting an modified record in the edit-grid (right-click a tabelname, choose Edit data), the message "Record is locked by another user" appears. The sessions-tool reveals no locks and typing the update on the same record in an SQL window or in SQL Plus causes no errormessages (i.e. the update is succesfull).
It seems that the edit-grid "remembers" previous locks and does not release them.

Regards,
Michael Doel
Wildher ICT Solutions

 

[Marco Kalter]

The message "Record locked by another user" can only occur if an "ORA-00054: resource busy and acquire with NOWAIT specified" error has been raised by Oracle. In other words, the record must have been locked. I can't think of any other explanation.

 

[Michael Doel]

If the record was locked, then a manual update statement in a SQL window in the same session or in SQL Plus in, of course, a different session could not both result in a succesfull update.
On top of that, the sessions-tool showed no locks on any table when viewed by a user with DBA privileges. So, if the record was really locked, then the sessions tool shows incomplete information.

 

[Marco Kalter]

Unless the lock was released by then. Maybe that was the case? Is it reproducible?

 

[Michael Doel]

The error is reproducable, even after restarting PLSQL developer