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>
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 ParkReceived on Mon Jun 21 1993 - 21:00:33 CEST