Re: Lock detection and resolution

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Thu, 24 May 2001 16:58:48 GMT
Message-ID: <3b0d3b9e.23188499@news-server>

On 24 May 2001 08:54:19 -0700, onlyforposting_at_yahoo.com (Vikas Agnihotri) wrote:

>
>Basically, my developers are asking if there is a way that, given a
>empno, they can query Oracle internals to find out if that row is
>free'n'clear or locked by a uncommited tranaction?
>

SELECT ..... FOR UPDATE OF .... NOWAIT
FROM ....

.
.
.
.

Check return code.

It's in the "manuels"...

HTH Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Thu May 24 2001 - 11:58:48 CDT