RE: Locking question

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Mon, 16 Oct 2000 11:21:20 -0400
Message-Id: <10651.119326@fatcity.com>

You can use select for update nowait in conjunction with dbms_lock.sleep which would effectively simulate timeout on the lock.

-----Original Message-----
From: John McCabe [mailto:johnm9563_at_netscape.net] Sent: Friday, October 13, 2000 6:06 PM
To: Multiple recipients of list ORACLE-L Subject: Locking question

HI all:

Is there an easy solution to this :

I have one process that has not committed and is holding a lock on a record.

Process #2 wants to update the same record. Is there any way to tell process
#2 to only wait X amount of time before returning an error or have the error returned immedialty? In other words if the record is locked, I do not want process #2 to wait until it is unlocked, I want to tell it how long to wait, then give me an error.

thanks

---

Get your own FREE, personal Netscape WebMail account today at http://home.netscape.com/webmail
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: John McCabe
  INET: johnm9563_at_netscape.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Oct 16 2000 - 10:21:20 CDT