Hi,
I'm trying to ensure that a row level trigger fires before a statement level trigger ( the other way round seems to be the default!). Initially I tried to use the FOLLOWS Clause in the statement level trigger, unfortunately this gave rise to the following error message:
Error: ORA-25022: cannot reference a trigger of a different type
I then tried to solve that problem by using 2 compound triggers with the FOLLOWS clause in the trigger that I wanted to execute 'second':
CREATE TRIGGER trig1
FOR UPDATE
ON table1
COMPOUND TRIGGER
BEFORE EACH ROW IS
BEGIN
...
END BEFORE EACH ROW
END trig1;
CREATE TRIGGER trig2
FOR UPDATE ...
ON table1
FOLLOWS trig1
COMPOUND TRIGGER
BEFORE STATEMENT IS
BEGIN
...
...
END STATEMENT ;
END trig2;
Both triggers compiled but still do not execute in the order that I want them to. Does anyone have an explantion for this behaviour or a solution to get the triggers to execute in the order I want? I am using Oracle 11g
regards,
Kevin.