Re: User/Transaction information from triggers

From: Philippe ARNAUD <parnau_at_ctp.com>
Date: Fri, 23 Oct 1998 08:59:01 +0200
Message-ID: <70p9i2$p39$1@concorde.ctp.com>

use oracle packages:

User Connection ID ----> DBMS_SESSION.UNIQUE_SESSION_ID

Transaction ID ----> DBMS_TRANSACTION.LOCAL_TRANSACTION_ID

Chris.Anglin_at_Synchrologic.com wrote in message <70o11o$gfc$1_at_nnrp1.dejanews.com>...
>Is it possible to gather user and transaction information in a trigger?
>Specifically, I would like to get the user connection ID and an ID for the
>transaction that caused the trigger to fire. In the case of cascading
>triggers, I would like to have knowledge of the orginating tranaction.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Oct 23 1998 - 01:59:01 CDT