Writing audit trails to a custom table.
520146Dec 28 2007 — edited Dec 31 2007Hi,
I want to capture the changes made to some of the tables in my application. Now I have the option of writing after insert / update triggers that will capture these changes and add an entry to a specific table lets say my_audit_trail with the row's primary key.
Instead of doing this I want a solution where in I can configure the tables and columns on those tables on which this needs to be done and have a generic procedure/handler that will take care of the changes by capturing what was the old data and the new one.
I have checked for the dbms_fga feature of oracle but it captures the data in the oracle's system auditing table which I dont want. Is there a possibility where in I can call a handler (my custom procedure like a trigger) where in I can get the old and the new row like we do in a trigger and capture the data in my custom table?