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

Home -> Community -> Usenet -> c.d.o.server -> Need to get current transaction identifier

Need to get current transaction identifier

From: user <user_at_cisco.com>
Date: Fri, 26 Mar 1999 13:26:27 -0800
Message-ID: <36FBFB83.5F8BE10@cisco.com> 





Anyone-


        I'm working on implementing some logging triggers for a database that
is shared by several applications.  I'd like to be able to group changes
by transaction.  Anyone know of a way to get a transaction ID from a
backend trigger?  I could use this to determine whether to start a new
group record each time an update trigger fires.


        If not, I'll have to have each of the front-end apps increment a
package variable after each commit.



TIA for any thoughts...



Keith Miller
Received on Fri Mar 26 1999 - 15:26:27 CST












Original text of this message













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