how to unlock specific row without completing transaction?
ZASep 21 2010 — edited Sep 21 2010Forms6i and Oracle9i
I have a multi-record database block based on a view. It does not allow any DML operations. But there is a checkbox (control-item) on the same block which is updateable, and if checked should LOCK the record. Intention is to display a message to other concurrent user that "Record currently in use".
User can select multiple records by checking the checkbox. I can lock the record using SELECT ... FOR UPDATE when checkbox is checked, but I want to UNLOCK the specific row if user unchecks the checkbox.
Is there any way to unlock a specific row without using ROLLBACK or COMMIT since they would rollback (may be to a savepoint) or commit whole transaction which may not be intended at that point.
Any thoughts would be helpful.