Here's the situation:
Im on a block. I do a change. Im locking the row. And its normal
I have a record in the V$LOCKED_OBJECT.

SQL> SELECT * FROM V$LOCKED_OBJECT;

XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME OS_USER_NAME PROCESS LOCKED_MODE
---------- ---------- ---------- ---------- ---------- ------------------------------ ------------------------------ --------- -----------
6 21 29574 64134 57 DEMO40 steve 1288:848 2

I do a KEY-ENTQRY and it ask me "Do you want to save the changes you made?" I say NO. -->im still locking the row!!, why? Even if i said no--> i still have a row in the V$LOCKED_OBJECT.

If i open another form and i make a change, it says: "Could not reserve record. Keep trying?".


How can i release the lock even do i said no to :"do you want to save my changes".