Dynamic Trigger
I am looking for documentation on Dynamic Triggers and cannot seem to find any good documentation or hints towards how they are used. The one thing I am picking up is that if you need to compare old and new values, the Dynamic trigger is the way to go as opposed to just creating a trigger directly in oracle.
My situation is that I need to detect changes in the cost center for a payroll integration. This works off of the PAY_COST_ALLOCATIONS_F table. When I go to generate the dynamic trigger I get a message indicating that: