I have the script:
Code: Select all
CREATE TRIGGER TR_DETAIL_FILES
AFTER UPDATE OF PERIOD_DATE_STAMP, IS_ACTIVE ON DETAIL_FILES
FOR EACH ROW
BEGIN
UPDATE CALLS
SET DETAIL_FILE_IS_ACTIVE=NEW.IS_ACTIVE,
DETAIL_FILE_PERIOD_DATE_STAMP=NEW.PERIOD_DATE_STAMP
WHERE DETAIL_FILE_ID=NEW.DETAIL_FILE_ID;
END;
Code: Select all
CREATE TRIGGER TR_DETAIL_FILES
AFTER UPDATE OF PERIOD_DATE_STAMP, IS_ACTIVE ON DETAIL_FILES
FOR EACH ROW
BEGIN
UPDATE CALLS
SET DETAIL_FILE_IS_ACTIVE=NEW.IS_ACTIVE,
DETAIL_FILE_PERIOD_DATE_STAMP=NEW.PERIOD_DATE_STAMP
WHERE DETAIL_FILE_ID=NEW.DETAIL_FILE_ID
Thanks,
Dmitry Ukolov.