Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need current transaction information
Seems to me that you should look into database triggers.
Look in Oracle 7 server application developers guide.
There are some good examples on how to, and they have an example on just
the thing you want to do in section Using Database Triggers.
best regards.
Carl Bruhn
crb_at_dde.dk
Gerry West wrote:
> Hi,
>
> I'd like to perform a transaction from a trigger
> and then capture
> - the OS user that performed the transaction,
> - the type of transaction
> - the table the transaction touched.
>
> I realize this information is available in dba_audit_trail,
> but how do you select for the current (right now) information
> for the current transaction ?
>
> Thanks in advance,
> Gerry
Received on Fri Feb 05 1999 - 02:58:43 CST