Re: How to know if a TABLE or ROW is locked?

A copy of this was sent to robert.bowen_at_mubimedia.com (if that email address didn't require changing) On Fri, 23 Jul 1999 16:26:16 GMT, you wrote:

>Simple question... Instead of waiting for my PL/SQL cgi to timeout, in
>the event that I can't do an update because a table or row is locked,
>is there some kind of query I can run? Like a 'isLocked()' function or
>something?
>

instead of updating the row directly do this:

   select * from T where <whatever conditions> FOR UPDATE NOWAIT;    update T set .... where <whatever conditions>;

if the select for update nowait errors out -- someone else has that data locked.

>Thanks in advance!
>syg
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
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 Fri Jul 23 1999 - 12:41:30 CDT