Re: How to get current transaction ID

From: <mpir_at_compuserve.com>
Date: Tue, 22 Dec 1998 15:55:21 GMT
Message-ID: <75ofd7$f8a$1@nnrp1.dejanews.com>

It is not quite a transaction ID, but if you check V$SESSION and V$PROCESS you should be able to get enought info. A lot of it depends on what your transaction (how many dml statements between commits) is doing.

In article <367f0baf.0_at_nemo.idirect.com>, "John Smith" <johnsmith120_at_hotmail.com> wrote:
> Hi,
>
> I prepare triggers on a few tables to monitor changes. I need to know that
> some of them were done in one and the same transaction. I think that the
> best way to get it is to write current transaction id to my audit tables.
> Any idea how to get current transaction id in database trigger?
>
> Thanks in advance,
> John
> johnsmith120_at_hotmail.com
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 22 1998 - 09:55:21 CST