Who locks what ?

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Mon, 21 Feb 2000 10:17:38 GMT
Message-ID: <6h8s4.7$mN.511@nreader3.kpnqwest.net>

Hi !

I manage locks into my database with SELECT ... FOR UPDATE NOWAIT.

When a record is already locked by another user, I wish to know who is locking the record I am trying to lock, in order to display a message to the user, such as "User toto is locking this record".

I know the locked objects with the v$lock view and the "locker", but I don't know who locks a particular record !

An idea ?

---

Didier LENQUETTE
Tel : (33) 5 62 12 20 40
Fax : (33) 5 61 31 07 02 Received on Mon Feb 21 2000 - 04:17:38 CST