Hello,
In our environment there is a trigger with below construct, which seemed to have fired twice for same condition. It has happened just once till date. Is there any know issue/cause which can end up on false execution of this type of trigger?
CREATE OR REPLACE TRIGGER XYZ
AFTER UPDATE OF column ON table
FOR EACH ROW
WHEN (
old.column <> new.column AND new.column IN (1,2,4)
Regards,
RB