Timeout on DBMS-Locks

From: Guenter Brors <brorsg_at_ibm.net>
Date: 1995/08/28
Message-ID: <41rnmo$2t60_at_news-s01.ny.us.ibm.net>#1/1

Is there any way to get a timeout when waiting on DBMS-locks?

 When I do SELECT FOR UPDATE and the row is locked by another user, I do not want to wait forever, but I'd rather get an error code after 60 seconds. I have found no way to program this and no Oracle parameter to specify it (only a parameter for distributed databases).

I cannot believe that the highly praised and commonly used Oracle system does not provide this feature.

I'm using Oracle 7.1.16 on RS/6000 and SQL*Net 2.0 on MS-Windows, with Pro*Cobol embedded SQL and ODBC.

---

Guenter Brors - Consultant Client/Server Solutions Internet: brorsg_at_ibm.net
CompuServe: 100137,2305
Phone: +49(40)6913629 Hamburg

---

Received on Mon Aug 28 1995 - 00:00:00 CEST