Trigger - How to audit cascading table - Urgent Please help me
881298Aug 9 2011 — edited Aug 9 2011Hi
I have to audit the changes in a table T1 for the changes that are happening in the table T4. (During the audit event this table inserts records in to atleast four tables).
here is the scenario:
---There is a table Employee(employee Id) , Project_Assignment(deptno), and Department (Dept Number).
I need to insert a row in the Audit_department table, when ever there is new row inserted into the Project Assignment Table.
I wrote after insert a trigger in the "Employee" table get the employee Id. There is also a new row inserted in the project assignment table, get the department no based on the new row.
Now I could not get the secondary table values based on the first table in the trigger. How can I do this triggers? I have Oracle 11g in our environment.
Please help me here.