Re: locked for update

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 01 Nov 1998 14:18:36 GMT
Message-ID: <363c6d8c.2482599@192.86.155.100>

A copy of this was sent to "Alex Buzunov" <sun_at_goldentele.com> (if that email address didn't require changing) On Sat, 31 Oct 1998 14:24:28 +0200, you wrote:

>Hi, All
>
>Could you pls. tell me how I could check in stored procedure whether a row
>in a table locked for update?
>
>Thanx in advance!
>
>AB
>

use

select * from T where <conditions> FOR UPDATE NOWAIT;

that will tell you if the row is locked for update by someone else (if it errors out) and lock it for you.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Nov 01 1998 - 08:18:36 CST