Interesting question about locks !

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.

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

Example :
User A lock row #1 and #3 of table1
User B tries to lock row #3 of table1 : he becomes error -54 OK ! I want to know who is locking row #3 in order to display a message like 'User A locks row #3'

An idea ?

--

________________
Didier LENQUETTE
Tel :  (33) 5 62 12 20 40
Fax : (33) 5 61 31 07 02