Re: Who locked these ROWS ??

sahmad_at_mfa.com (Saad Ahmad) writes:

>Jagannath Poosarla (poosarla_at_aadt.com) wrote:
>> Is it possible to find out in a trigger which OS user has locked the row for which the
>> insert/update/delete trigger was fired.
 

>id1 field in v$lock is the object_id of the table.

And can I get the ROWID of the locked row ?

Thanks in advance

Helge Petersen                           Datenbankadministrator
Draeger Synematic GmbH                   D-23558 Luebeck, Germany
Tel. 0451/882-4044   Fax -3031           Email petersen_at_dwhl.de
***************************************************************************