Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to get current transaction ID

How to get current transaction ID

From: John Smith <johnsmith120_at_hotmail.com>
Date: Mon, 21 Dec 1998 22:02:33 -0800
Message-ID: <367f0baf.0@nemo.idirect.com> 





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


Received on Tue Dec 22 1998 - 00:02:33 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US