Need current transaction information

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 Thu Feb 04 1999 - 16:35:46 CST