아래와 같은 트리거를 작성했는데 컴파일시
오류(24,7): PLS-00103: 심볼 "FOR"를 만났습니다 다음 중 하나가 기대될 때: := . ( @ % ; 심볼이 ";" 계속하기 위하여 "FOR"로 치환되었습니다 발생하네요 고수님들의 조언 좀 부탁드립니다.
CREATE OR REPLACE TRIGGER TB_00001100_TRIG_INS_AF_01
AFTER INSERT ON TB_INFO_PACM_00001100
REFERENCING NEW AS NEW
FOR EACH ROW
DECLARE
V_COUNT_CNT INT := 0;
CURSOR CUR_CONT_ID IS
SELECT B.CONT_ID
FROM TB_INFO_PACM_00001000 A
, TB_INFO_PACM_00002000 B
WHERE A.MEM_COMY_CD = B.MEM_COMY_CD
AND A.MEM_COMY_CD = :NEW.MEM_COMY_CD
;
BEGIN
SELECT COUNT(*) INTO V_COUNT_CD FROM TB_INFO_PACM_11002000 A, TB_INFO_PACM_00002000 B WHERE A.CONT_ID = B.CONT_ID AND B.MEM_COMY_CD = :NEW.MEM_COMY_CD;
IF V_COUNT_ID = 0 THEN MEM_COMY_CD
FOR CONT_LIST IN CUR_CONT_ID LOOP
INSERT INTO TB_INFO_PACM_11002000
( USER_ID
, CONT_ID
, REG_NM
, REG_DT
, CHANG_NM
, CHANG_DT
)
VALUES
( :NEW.USER_ID
, CONT_LIST.CONT_ID
, :NEW.REG_NM
, :NEW.REG_DT
, :NEW.CHANG_NM
, :NEW.CHANG_DT
);
END LOOP;
END IF;
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('TB_00001100_TRIG_INS_AF_01 EXEC ERROR');
DBMS_OUTPUT.PUT_LINE('SQL ERROR CODE:' || SQLCODE);
DBMS_OUTPUT.PUT_LINE('SQL ERROR MESSAGE:' || SQLERRM);
END;