DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Forms 6i, locking

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    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".

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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
  •  


Click Here to Expand Forum to Full Width