Re: Isnt there anybody who can answer

Your question is too generalised for anyway to give a good answer. But you might want to look as the dbms_lock package in $ORACLE_HOME/rdbms/admin/dbmslock.sql as that might describe the sort of thing you are after.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Anurag Minocha wrote in message <37775140.D2398D38_at_synergy-infotech.com>...
>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.
>
>anurag
>
>
>reply at
>anurag_at_synergy-infotech.com
>
>
>
>
>
Received on Mon Jun 28 1999 - 06:07:12 CDT