-
Forms 6i, locking
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".
-
You can set locking to delayed via the property palette at the block level. You can also look this up on MetaLink. Locking mode = delayed.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|