Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

update of column list trigger not woring

Hameed BhattiAug 3 2020 — edited Aug 5 2020

I created a trigger on a table like:

CREATE OR REPLACE TRIGGER AMS_RECD_UPD_XXXXX

AFTER UPDATE OF ASTGEN_FLG

ON AMS_RECD

REFERENCING NEW AS NEW OLD AS OLD

FOR EACH ROW.....

according to documentation, this trigger should only fire when value of  ASTGEN_FLG is changed.

I am experiencing that this trigger fires whenever any column is updated.

This post has been answered by L. Fernigrini on Aug 3 2020
Jump to Answer
Comments
Post Details
Added on Aug 3 2020
23 comments
465 views