Re: how to test locks

From: Mladen Gogala <mgogala_at_earthlink.net>
Date: Thu, 24 Jan 2002 02:04:39 GMT
Message-ID: <pan.2002.01.23.21.04.19.670301.1011@earthlink.net>

On Wed, 23 Jan 2002 04:13:41 -0500, Youtz wrote:

> Why not using :
>
> select * from toto where L1 = 'z' for update NOWAIT;
>
> ERROR:
> ORA-00054: resource busy and acquire with NOWAIT specified
>
> and trapping the error ?
>
> best regards,
> Youtz.
>
>

The condition was to test for the locks and not cause a lock. In case that the row you're investing is not locked, your statement will lock it. In other words, the condions are not satisfied. Received on Wed Jan 23 2002 - 20:04:39 CST