Re: Transaction ID

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Fri, 5 Nov 1999 12:38:00 +0100
Message-ID: <7vufl7$3n6$1@oceanite.cybercable.fr>

You can get your transaction ID with this statement:

select t.xidusn, t.xidslot, t.xidsqn
from v$transaction t, v$session s
where t.ses_addr = s.saddr
and s.audsid=userenv('SESSIONID');

--
Have a nice day
Michel

Dave Waterworth <pscdaw_at_ihug.com.au> a écrit dans le message : 7vucj5$t4n$1_at_toto.tig.com.au...
> Hi
>
> Is there such a thing a a transaction id which is unique for every
> transaction executed by an instance(whether concurrent or sequential)? If so
> how can I determine it from within a trigger which is fired during the
> transaction?
>
> Regards
>
> Dave Wateworth
>
>
Received on Fri Nov 05 1999 - 05:38:00 CST