Audit plug in or trigger to add custom realtime data to audit

Migrateduser

Hi,

When an Audit is about to get written to the database, I need to be able to read some of its fields, perform some "realtime" data access to involved documents's other metadata value and other related information. In short, I need to take a picture of these values and store them somewhere (could be the audit's comment field)) or inserting the extra data inside another Oracle table.

Is there any kind of Audit plug in in TCP so we can write Java code to perform extra work before the audit record is written to the database ? It looks like this would be useful to many customers, no ?

Is there a kind of BOL trigger to achieve that ?

Should I add a trigger to Oracle for Audit Inserts, before they are commited to the database ? However, the PL-SQL code would need to know how to get data from the TCP documents. Not that obvious.

What would you recommend ?

Thanks,

Jean-Pierre