Re: Locking...finding out who's locked what.

From: Alvin W. Law <alaw_at_oracle.com>
Date: Mon, 21 Jun 1993 19:00:33 GMT
Message-ID: <ALAW.93Jun21110033_at_ap221sun.oracle.com>


roleary_at_st.nepean.uws.edu.au (Rocqueforte OLeary) writes:

> In SQL*Forms 3.0 I have a from which has implemented locking through
> enter_query(for_update,no_wait). This works fine, but instead of the
> standard error message of "Attempting to reserve record for update or
> delete", I would like to display a message such as "OPS$JBLOGGS has
> locked 1 or more rows that are in your query". Does anyone out there
> know how to do this ?

You can get a list of table locking from v$access and the complete list of processes from v$process.

--
 Alvin W. Law .............................................. Oracle Corporation
 Senior Software Engineer ...................... 300 Oracle Parkway, Box 659306
 Manufacturing Applications .......................... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1.415.506.3390 .... Fax: +1.415.506.7299

      "Geez, it's an UNIX system."
			- Jurassic Park
Received on Mon Jun 21 1993 - 21:00:33 CEST

Original text of this message