Re: Transactions

There are three columns in the dynamic view v$transaction which uniquely identify each transaction, these are

    xidusn, xidslot, xidsqn.

The funtion dbms_util.local_transaction_id returns this set of values as a character string in the form:

    xidusn.xidslot.xidsqn
If called using:

    dbms_util.local_transaction_id(TRUE) the function will start a transaction if one is not already running.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Peter Morris wrote in message <9sounq$24p$1_at_lyonesse.netcom.net.uk>...


>When running a transaction in ORACLE, is there

>some kind of  identifier that uniquely identifies the

>particular transaction?  If so,  is there a function

>that returns the identifier, which I can call from

>inside a trigger firedby the transaction?

>

>

>

>--

>    ______________________________

>   /____________________________(_)

>   |     ___________________________              email to

>   |     |  |________________________(_)             Peter_Morris_1

>   |     |/__________________________              at  Hotmail dot com

>   |____________________________(_)

>

>