Re: Locking...finding out who's locked what.
From: Mike Oswald <moswald_at_cwis.unomaha.edu>
Date: Mon, 21 Jun 1993 15:24:57 GMT
Message-ID: <1993Jun21.152457.15576_at_news.unomaha.edu>
Date: Mon, 21 Jun 1993 15:24:57 GMT
Message-ID: <1993Jun21.152457.15576_at_news.unomaha.edu>
roleary_at_st.nepean.uws.edu.au writes:
> G'day,
> 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 ?
There are a series of V$... tables that will let you know who is accessing what table but I have not tried checking to see if someone has the rowid that I am updating.
Mike. Received on Mon Jun 21 1993 - 17:24:57 CEST