I have two triggers on the Oracle table which I cannot alter because they are the vendors triggers. I want to use the FOLLOWING clause such that their triggers always fire first but therein lies the problem.
They are BEFORE INSERT and BEFORE UPDATE triggers supplied by the vendor. In order to use my triggers after theirs the FOLLOWING clause requires the triggers to be the same "type" of trigger. (compound trigger could potentially get me from the mutating situation)
Is there a way around PRAGMA AUTONOMOUS_TRANSACTION to get this to work?
I have to update the table that is being updated.....if a new row is entered I have to update the row prior with the new prices.
Any help would be appreciated.