제가 만든 트리거 내용입니다.
CREATE OR REPLACE TRIGGER TRIGER_FNW_ADM_MBER_SITE_INS
AFTER
INSERT ON FNW_ADM_MBER_SITE
FOR EACH ROW
BEGIN
INSERT INTO FNW_ADM_MBER_SITE_HIST VALUES (:new.SITE_ID, :new.ADM_ID, :new.APT_DATE, SYSDATE, 'INSERT');
END;
이후 트리거가 잘 동작하는지 판단하기 위하여
INSERT INTO FNW_ADM_MBER_SITE
(SITE_ID, ADM_ID, APT_DATE)
VALUES
('fdsa', 'fdsa', sysdate)
쿼리를 실행시켰습니다.
쿼리를 실행할 때 트리거 부적합 오류가 발생되어 질문드립니다.
오류내용
SQL 오류: ORA-04098: 'EPISFOOD.TRIGER_FNW_ADM_MBER_SITE_INS' 트리거가 부적합하며 재검증을 실패했습니다
04098. 00000 - "trigger '%s.%s' is invalid and failed re-validation"
*Cause: A trigger was attempted to be retrieved for execution and was
found to be invalid. This also means that compilation/authorization
failed for the trigger.
*Action: Options are to resolve the compilation/authorization errors,
disable the trigger, or drop the trigger.