Re: Who locked these ROWS ??

From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1995/10/12
Message-ID: <45hp65$ool_at_homer.alpha.net>#1/1


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.

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************
Received on Thu Oct 12 1995 - 00:00:00 CET

Original text of this message