Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need to get current transaction identifier
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
![]() |
![]() |