Re: Isnt there anybody who can answer

A copy of this was sent to Anurag Minocha <anurag_at_synergy-infotech.com> (if that email address didn't require changing) On Mon, 28 Jun 1999 16:11:05 +0530, you wrote:

>I had posted one question . The subject was
> Identifying whether a particular lock is active or not.
>
>Is'nt there anybody who can answer This .If yes i am sending the
>question again with this mail
>
>Hi ,
>Is there a way i can assign a number to a lock (select ... for update)
>and then find out from some other procedure that whether that particular
>
>lock is active or not. Please Help me out with this or suggest some
>other method to do this.
>

dbms_lock is one method.

have you looked at "select .... from T for update NOWAIT"

if you are trying to find out in a non-blocking fashion if a row is locked, the select for udpate NOWAIT will do it as well.

>anurag
>
>
>reply at
>anurag_at_synergy-infotech.com
>
>
>
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 28 1999 - 09:58:20 CDT