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 -> Re: Need to get current transaction identifier

Re: Need to get current transaction identifier

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 28 Mar 1999 09:31:21 +0100
Message-ID: <922610245.21399.0.nnrp-09.9e984b29@news.demon.co.uk>


Have a look in dbmsutil.sql at the dbms_transaction package. There is a function to handle guaranteed local transaction ids.

I believe this exists in both 7 and 8
--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

user wrote in message <36FBFB83.5F8BE10_at_cisco.com>...
> 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.
Received on Sun Mar 28 1999 - 02:31:21 CST

Original text of this message

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