|
exp만 하다가 오늘 테스트로 imp 해 봤는데 오류가 나옵니다
해결 방법 좀 부탁드립니다
. . 테이블 "USER_SURYO_PRINT"(를)을 임포트 중 484 행이 임포트 되었습니다.
. . 테이블 "USER_ZZIM"(를)을 임포트 중 12 행이 임포트 되었습니다.
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER CHORG.TR_AG_SCORE_HIST "
"AFTER INSERT OR DELETE "
"OR UPDATE ON CHORG.HOMEWORK "
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW "
"BEGIN "
" IF INSERTING THEN "
" INSERT INTO HRDREMOTE.TB_SCORE_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" EVAL_TYPE,"
" SUBMIT_DATE,"
" SCORE,"
" ACCESS_IP,"
" SUBMIT_DUE_DT,"
" CHANGE_STATE,"
" IS_COPIED_ANSWER,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_SCORE_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" '과제',"
" TO_DATE(:NEW.WDATE ),"
" :NEW.RECORDS,"
" NULL, -- 접속 IP를 저장하지 않음"
" NULL, -- 제출기한이 없음"
" 'C', "
" 'N',"
" SYSDATE"
" );"
" ELSIF UPDATING THEN"
" IF :OLD.RECORDS != :NEW.RECORDS THEN "
" INSERT INTO HRDREMOTE.TB_SCORE_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" EVAL_TYPE,"
" SUBMIT_DATE,"
" SCORE,"
" ACCESS_IP,"
" SUBMIT_DUE_DT,"
" CHANGE_STATE,"
" IS_COPIED_ANSWER,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_SCORE_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" '과제',"
" TO_DATE(:NEW.WDATE ),"
" :NEW.RECORDS,"
" NULL, -- 접속 IP를 저장하지 않음"
" NULL, -- 제출기한이 없음"
" 'U', "
" 'N',"
" SYSDATE"
" );"
" END IF; "
" ELSIF DELETING THEN"
" INSERT INTO HRDREMOTE.TB_SCORE_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" EVAL_TYPE,"
" SUBMIT_DATE,"
" SCORE,"
" ACCESS_IP,"
" SUBMIT_DUE_DT,"
" CHANGE_STATE,"
" IS_COPIED_ANSWER,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_SCORE_HIST.NEXTVAL,"
" :OLD.USERID,"
" :OLD.CNO,"
" :OLD.CATE_UID,"
" '과제',"
" TO_DATE(:OLD.WDATE ),"
" :OLD.RECORDS,"
" NULL, -- 접속 IP를 저장하지 않음"
" NULL, -- 제출기한이 없음"
" 'D', "
" 'N',"
" SYSDATE"
" );"
" END IF; "
"END ;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER CHORG.TR_AG_SCORE_HIST_1 "
"AFTER INSERT OR DELETE "
"OR UPDATE ON CHORG.CATE_EXAM_RESULT"
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW "
"BEGIN "
" IF INSERTING THEN "
" INSERT INTO HRDREMOTE.TB_SCORE_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" EVAL_TYPE,"
" SUBMIT_DATE,"
" SCORE,"
" ACCESS_IP,"
" SUBMIT_DUE_DT,"
" CHANGE_STATE,"
" IS_COPIED_ANSWER,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_SCORE_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" '½ÃÇè',"
" sysdate,"
" :NEW.TOTAL_RECORD,"
" NULL, -- 접속 IP를 저장하지 않음"
" NULL, -- 제출기한이 없음"
" 'C', "
" 'N',"
" SYSDATE"
" );"
" ELSIF UPDATING THEN"
" IF :OLD.TOTAL_RECORD != :NEW.TOTAL_RECORD THEN "
""
""
" INSERT INTO HRDREMOTE.TB_SCORE_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" EVAL_TYPE,"
" SUBMIT_DATE,"
" SCORE,"
" ACCESS_IP,"
" SUBMIT_DUE_DT,"
" CHANGE_STATE,"
" IS_COPIED_ANSWER,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_SCORE_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" '½ÃÇè',"
" sysdate,"
" :NEW.TOTAL_RECORD,"
" NULL, -- 접속 IP를 저장하지 않음"
" NULL, -- 제출기한이 없음"
" 'U', "
" 'N',"
" SYSDATE"
" );"
" END IF; "
" ELSIF DELETING THEN"
""
" INSERT INTO HRDREMOTE.TB_SCORE_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" EVAL_TYPE,"
" SUBMIT_DATE,"
" SCORE,"
" ACCESS_IP,"
" SUBMIT_DUE_DT,"
" CHANGE_STATE,"
" IS_COPIED_ANSWER,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_SCORE_HIST.NEXTVAL,"
" :OLD.USERID,"
" :OLD.CNO,"
" :OLD.CATE_UID,"
" '½ÃÇè',"
" sysdate,"
" :OLD.TOTAL_RECORD,"
" NULL, -- 접속 IP를 저장하지 않음"
" NULL, -- 제출기한이 없음"
" 'D', "
" 'N',"
" SYSDATE"
" );"
" END IF; "
"END ;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER CHORG.TR_AG_SCORE_HIST_2"
"AFTER INSERT OR DELETE "
"OR UPDATE OF VIEW_CNT ON CHORG.USER_CATE_CHACK"
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW "
"BEGIN "
" IF INSERTING THEN "
" INSERT INTO HRDREMOTE.TB_SCORE_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" EVAL_TYPE,"
" SUBMIT_DATE,"
" SCORE,"
" ACCESS_IP,"
" SUBMIT_DUE_DT,"
" CHANGE_STATE,"
" IS_COPIED_ANSWER,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_SCORE_HIST.NEXTVAL,"
" :NEW.MB_ID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" 'Áøµµ',"
" NULL, "
" (:NEW.VIEW_CNT / DECODE( :NEW.CATE_CNT, 0,1,:NEW.CATE_CNT ) ) *"
" 100,"
" NULL, -- 접속 IP를 저장하지 않음"
" NULL, -- 제출기한이 없음"
" 'C', "
" 'N',"
" SYSDATE"
" );"
" ELSIF UPDATING THEN"
" IF :OLD.VIEW_CNT != :NEW.VIEW_CNT THEN "
""
" INSERT INTO HRDREMOTE.TB_SCORE_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" EVAL_TYPE,"
" SUBMIT_DATE,"
" SCORE,"
" ACCESS_IP,"
" SUBMIT_DUE_DT,"
" CHANGE_STATE,"
" IS_COPIED_ANSWER,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_SCORE_HIST.NEXTVAL,"
" :NEW.MB_ID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" 'Áøµµ',"
" NULL,"
" (:NEW.VIEW_CNT / DECODE( :NEW.CATE_CNT, 0,1,:NEW.CATE_CNT )"
" ) * 100,"
" NULL, -- 접속 IP를 저장하지 않음"
" NULL, -- 제출기한이 없음"
" 'U', "
" 'N',"
" SYSDATE"
" );"
" END IF; "
" ELSIF DELETING THEN"
""
" INSERT INTO HRDREMOTE.TB_SCORE_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" EVAL_TYPE,"
" SUBMIT_DATE,"
" SCORE,"
" ACCESS_IP,"
" SUBMIT_DUE_DT,"
" CHANGE_STATE,"
" IS_COPIED_ANSWER,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_SCORE_HIST.NEXTVAL,"
" :OLD.MB_ID,"
" :OLD.CNO,"
" :OLD.CATE_UID,"
" 'Áøµµ',"
" NULL,"
" (:OLD.VIEW_CNT / DECODE( :OLD.CATE_CNT, 0,1,:OLD.CATE_CNT ) ) * "
"100,"
" NULL, -- 접속 IP를 저장하지 않음"
" NULL, -- 제출기한이 없음"
" 'D', "
" 'N',"
" SYSDATE"
" );"
" END IF; "
"END ;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER CHORG.TR_AG_ATTEND_RESULT_HIST"
"AFTER INSERT OR DELETE "
"OR UPDATE ON CHORG.HOMEWORK "
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW "
"DECLARE"
" V_OutScore number;"
" V_OutProgress number; "
" "
"BEGIN "
" IF INSERTING THEN "
" SP_MAKE_TOTAL_SCORE( to_char( :NEW.CNO ),to_char( :NEW.CATE_UID ),"
"to_char( :NEW.USERID ),V_OutScore,V_OutProgress );"
" INSERT INTO HRDREMOTE.TB_ATTEND_RESULT_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" TOTAL_SCORE,"
" PROGRESS_RATE,"
" CHANGE_STATE,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_ATTEND_RESULT_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" V_OutScore,"
" V_OutProgress,"
" 'C',"
" SYSDATE"
" );"
" ELSIF UPDATING THEN"
" SP_MAKE_TOTAL_SCORE ( :NEW.CNO,:NEW.CATE_UID,:NEW.USERID,V_OutScore,V"
"_OutProgress ); "
" INSERT INTO HRDREMOTE.TB_ATTEND_RESULT_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" TOTAL_SCORE,"
" PROGRESS_RATE,"
" CHANGE_STATE,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_ATTEND_RESULT_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" V_OutScore,"
" V_OutProgress,"
" 'U',"
" SYSDATE"
" );"
" "
" ELSIF DELETING THEN"
" SP_MAKE_TOTAL_SCORE( :OLD.CNO,:OLD.CATE_UID,:OLD.USERID,V_OutScore,V"
"_OutProgress ); "
" INSERT INTO HRDREMOTE.TB_ATTEND_RESULT_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" TOTAL_SCORE,"
" PROGRESS_RATE,"
" CHANGE_STATE,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_ATTEND_RESULT_HIST.NEXTVAL,"
" :OLD.USERID,"
" :OLD.CNO,"
" :OLD.CATE_UID,"
" V_OutScore,"
" V_OutProgress,"
" 'D',"
" SYSDATE"
" );"
" "
" END IF; "
"END ;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER CHORG.TR_AG_ATTEND_RESULT_HIST_1"
"AFTER INSERT OR DELETE "
"OR UPDATE ON CHORG.CATE_EXAM_RESULT "
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW "
"DECLARE"
" V_OutScore number;"
" V_OutProgress number; "
" "
"BEGIN "
" IF INSERTING THEN "
" SP_MAKE_TOTAL_SCORE( to_char( :NEW.CNO ),to_char( :NEW.CATE_UID ),to"
"_char( :NEW.USERID ),V_OutScore,V_OutProgress );"
" INSERT INTO HRDREMOTE.TB_ATTEND_RESULT_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" TOTAL_SCORE,"
" PROGRESS_RATE,"
" CHANGE_STATE,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_ATTEND_RESULT_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" V_OutScore,"
" V_OutProgress,"
" 'C',"
" SYSDATE"
" );"
" ELSIF UPDATING THEN"
" SP_MAKE_TOTAL_SCORE ( :NEW.CNO,:NEW.CATE_UID,:NEW.USERID,V_OutScore,V_"
"OutProgress ); "
" INSERT INTO HRDREMOTE.TB_ATTEND_RESULT_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" TOTAL_SCORE,"
" PROGRESS_RATE,"
" CHANGE_STATE,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_ATTEND_RESULT_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" V_OutScore,"
" V_OutProgress,"
" 'U',"
" SYSDATE"
" );"
" "
" ELSIF DELETING THEN"
" SP_MAKE_TOTAL_SCORE( :OLD.CNO,:OLD.CATE_UID,:OLD.USERID,V_OutScore,V_"
"OutProgress ); "
" INSERT INTO HRDREMOTE.TB_ATTEND_RESULT_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" TOTAL_SCORE,"
" PROGRESS_RATE,"
" CHANGE_STATE,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_ATTEND_RESULT_HIST.NEXTVAL,"
" :OLD.USERID,"
" :OLD.CNO,"
" :OLD.CATE_UID,"
" V_OutScore,"
" V_OutProgress,"
" 'D',"
" SYSDATE"
" );"
" "
" END IF; "
"END ;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER CHORG.TR_AG_ATTEND_RESULT_HIST_2"
"AFTER INSERT OR DELETE "
"OR UPDATE ON CHORG.USER_CATE_CHACK "
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW "
"DECLARE"
" V_OutScore number;"
" V_OutProgress number; "
" "
"BEGIN "
" IF INSERTING THEN "
" SP_MAKE_TOTAL_SCORE( to_char( :NEW.CNO ),to_char( :NEW.CATE_UID ),to"
"_char( :NEW.MB_ID ),V_OutScore,V_OutProgress );"
" INSERT INTO HRDREMOTE.TB_ATTEND_RESULT_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" TOTAL_SCORE,"
" PROGRESS_RATE,"
" CHANGE_STATE,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_ATTEND_RESULT_HIST.NEXTVAL,"
" :NEW.MB_ID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" V_OutScore,"
" V_OutProgress,"
" 'C',"
" SYSDATE"
" );"
" ELSIF UPDATING THEN"
" SP_MAKE_TOTAL_SCORE ( to_char( :NEW.CNO ),to_char( :NEW.CATE_UID ),to"
"_char( :NEW.MB_ID ),V_OutScore,V_OutProgress );"
" INSERT INTO HRDREMOTE.TB_ATTEND_RESULT_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" TOTAL_SCORE,"
" PROGRESS_RATE,"
" CHANGE_STATE,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_ATTEND_RESULT_HIST.NEXTVAL,"
" :NEW.MB_ID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" V_OutScore,"
" V_OutProgress,"
" 'U',"
" SYSDATE"
" );"
" "
" ELSIF DELETING THEN"
" SP_MAKE_TOTAL_SCORE( to_char( :OLD.CNO ),to_char( :OLD.CATE_UID ),to"
"_char( :OLD.MB_ID ),V_OutScore,V_OutProgress );"
" INSERT INTO HRDREMOTE.TB_ATTEND_RESULT_HIST"
" ("
" SEQ,"
" USER_AGENT_PK,"
" COURSE_AGENT_PK,"
" CLASS_AGENT_PK,"
" TOTAL_SCORE,"
" PROGRESS_RATE,"
" CHANGE_STATE,"
" REG_DATE"
" ) VALUES "
" ("
" HRDREMOTE.SEQ_ATTEND_RESULT_HIST.NEXTVAL,"
" :OLD.MB_ID,"
" :OLD.CNO,"
" :OLD.CATE_UID,"
" V_OutScore,"
" V_OutProgress,"
" 'D',"
" SYSDATE"
" );"
" "
" END IF; "
"END ;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER CHORG.TR_AG_CLASS_HIST"
"AFTER INSERT OR DELETE "
"OR UPDATE OF NUM, COURSE_ID,CATEGORY_ID ON CHORG.COURSE_GWAMOK REFERENCING"
" NEW AS NEW OLD AS OLD"
"FOR EACH ROW"
"DECLARE"
" V_STARTDATE VARCHAR(100); -- FORMDATE2, "
" V_ENDTDATE VARCHAR(100); -- TODATE2"
" V_EDU_REFUND VARCHAR(10); -- EDU_REFUND "
" V_TOTAL_SCORE NUMBER; "
"BEGIN "
""
" IF INSERTING THEN"
" "
" SELECT FROMDATE2 , TODATE2 , EDU_REFUND , TO_NUMBER(P_METHOD1) +T"
"O_NUMBER( P_METHOD2 ) +TO_NUMBER( P_METHOD3 )+TO_NUMBER( P_METHOD4 )"
" INTO V_STARTDATE , V_ENDTDATE ,V_ENDTDATE, V_TOTAL_SCORE"
" FROM COURSE"
" WHERE NUM = :NEW.COURSE_ID"
" ;"
" "
" INSERT INTO HRDREMOTE.TB_CLASS_HIST ("
" SEQ, COURSE_AGENT_PK, CLASS_AGENT_PK, "
" FULL_SCORE, START_DT, END_DT, "
" EMP_INS_FLAG, VALID_FLAG, CHANGE_STATE, "
" REG_DATE) "
" VALUES ( HRDREMOTE.SEQ_CLASS_HIST.NEXTVAL,"
" :NEW.COURSE_ID,"
" :NEW.CATEGORY_ID,"
" V_TOTAL_SCORE,"
" V_STARTDATE,"
" V_ENDTDATE,"
" V_EDU_REFUND,"
" 1,"
" 'C',"
" SYSDATE "
" ); "
" "
""
" ELSIF UPDATING THEN "
" "
" SELECT FROMDATE2 , TODATE2 , EDU_REFUND , TO_NUMBER(P_METHOD1) +T"
"O_NUMBER( P_METHOD2 ) +TO_NUMBER( P_METHOD3 )+TO_NUMBER( P_METHOD4 )"
" INTO V_STARTDATE , V_ENDTDATE ,V_ENDTDATE, V_TOTAL_SCORE"
" FROM COURSE"
" WHERE NUM = :NEW.COURSE_ID"
" ;"
" "
" INSERT INTO HRDREMOTE.TB_CLASS_HIST ("
" SEQ, COURSE_AGENT_PK, CLASS_AGENT_PK, "
" FULL_SCORE, START_DT, END_DT, "
" EMP_INS_FLAG, VALID_FLAG, CHANGE_STATE, "
" REG_DATE) "
" VALUES ( HRDREMOTE.SEQ_CLASS_HIST.NEXTVAL,"
" :NEW.COURSE_ID,"
" :NEW.CATEGORY_ID,"
" V_TOTAL_SCORE,"
" V_STARTDATE,"
" V_ENDTDATE,"
" V_EDU_REFUND,"
" 1,"
" 'U',"
" SYSDATE "
" ); "
" ELSIF DELETING THEN"
" SELECT FROMDATE2 , TODATE2 , EDU_REFUND , TO_NUMBER(P_METHOD1) +T"
"O_NUMBER( P_METHOD2 ) +TO_NUMBER( P_METHOD3 )+TO_NUMBER( P_METHOD4 )"
" INTO V_STARTDATE , V_ENDTDATE ,V_ENDTDATE, V_TOTAL_SCORE"
" FROM COURSE"
" WHERE NUM = :OLD.COURSE_ID"
" ; "
" INSERT INTO HRDREMOTE.TB_CLASS_HIST ("
" SEQ, COURSE_AGENT_PK, CLASS_AGENT_PK, "
" FULL_SCORE, START_DT, END_DT, "
" EMP_INS_FLAG, VALID_FLAG, CHANGE_STATE, "
" REG_DATE) "
" VALUES ( HRDREMOTE.SEQ_CLASS_HIST.NEXTVAL,"
" :OLD.COURSE_ID,"
" :OLD.CATEGORY_ID,"
" V_TOTAL_SCORE,"
" V_STARTDATE,"
" V_ENDTDATE,"
" V_EDU_REFUND,"
" 1,"
" 'D',"
" SYSDATE "
" ); "
" END IF;"
" EXCEPTION"
" WHEN OTHERS THEN NULL;"
"END;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER "CHORG".TR_AG_CLASS_HIST_1"
"AFTER UPDATE OF FROMDATE2, TODATE2,EDU_REFUND,P_METHOD1,P_METHOD2,P_METHOD3"
",P_METHOD4 ON CHORG.COURSE"
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW"
"BEGIN "
""
" IF UPDATING THEN "
" "
" FOR REC1 IN ("
" SELECT COURSE_ID,CATEGORY_ID FROM CHORG.COURSE_GWAMOK"
" WHERE COURSE_ID = :NEW.NUM"
" )"
" LOOP"
" INSERT INTO HRDREMOTE.TB_CLASS_HIST ("
" SEQ, COURSE_AGENT_PK, CLASS_AGENT_PK, "
" FULL_SCORE, START_DT, END_DT, "
" EMP_INS_FLAG, VALID_FLAG, CHANGE_STATE, "
" REG_DATE) "
" VALUES ( HRDREMOTE.SEQ_CLASS_HIST.NEXTVAL,"
" REC1.COURSE_ID,"
" REC1.CATEGORY_ID,"
" TO_NUMBER( :NEW.P_METHOD1 ) + TO_NUMBER( :NEW.P_METHOD2 ) "
"+ TO_NUMBER( :NEW.P_METHOD3 )+ TO_NUMBER( :NEW.P_METHOD4 ) ,"
" :NEW.FROMDATE2,"
" :NEW.TODATE2,"
" :NEW.EDU_REFUND,"
" 1,"
" 'U',"
" SYSDATE "
" ); "
" END LOOP;"
""
" "
""
" END IF;"
" EXCEPTION"
" WHEN OTHERS THEN NULL;"
"END;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER "CHORG".TR_AG_ATTEND_HIST"
"AFTER INSERT OR DELETE OR UPDATE OF SEC,STIME,ETIME,CC_NUM,CC_SORT ON CHORG"
".TIMER"
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW"
"DECLARE "
" V_MAX_MINUTES NUMBER; "
"BEGIN "
""
" IF INSERTING THEN"
" SELECT MAX_MINUTES "
" INTO V_MAX_MINUTES "
" FROM COURSE"
" WHERE NUM =:NEW.CNO "
" ; "
" INSERT INTO HRDREMOTE.TB_ATTEND_HIST ("
" SEQ, USER_AGENT_PK, COURSE_AGENT_PK, "
" CLASS_AGENT_PK, PASS_FLAG, ATTEND_VALID_FLAG, "
" BOOK_ISBN, CHANGE_STATE, REG_DATE) "
" VALUES ("
" HRDREMOTE.SEQ_ATTEND_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" CASE WHEN TO_NUMBER( V_MAX_MINUTES )*60 >= :NEW.SEC THEN 0 "
" "
" WHEN TO_NUMBER( V_MAX_MINUTES )*60 < :NEW.SEC THEN 1"
" ELSE 0"
" END,"
" '1',"
" NULL,"
" 'C',"
" SYSDATE "
" );"
" ELSIF UPDATING THEN "
" SELECT MAX_MINUTES INTO V_MAX_MINUTES FROM COURSE"
" WHERE NUM =:NEW.CNO "
" ; "
" INSERT INTO HRDREMOTE.TB_ATTEND_HIST ("
" SEQ, USER_AGENT_PK, COURSE_AGENT_PK, "
" CLASS_AGENT_PK, PASS_FLAG, ATTEND_VALID_FLAG, "
" BOOK_ISBN, CHANGE_STATE, REG_DATE) "
" VALUES ("
" HRDREMOTE.SEQ_ATTEND_HIST.NEXTVAL,"
" :NEW.USERID,"
" :NEW.CNO,"
" :NEW.CATE_UID,"
" CASE WHEN TO_NUMBER( V_MAX_MINUTES )*60 >= :NEW.SEC THEN 0 "
" "
" WHEN TO_NUMBER( V_MAX_MINUTES )*60 < :NEW.SEC THEN 1"
" ELSE 0"
" END,"
" '1',"
" NULL,"
" 'U',"
" SYSDATE "
" );"
" ELSIF DELETING THEN "
" SELECT MAX_MINUTES INTO V_MAX_MINUTES FROM COURSE"
" WHERE NUM =:OLD.CNO "
" ; "
" INSERT INTO HRDREMOTE.TB_ATTEND_HIST ("
" SEQ, USER_AGENT_PK, COURSE_AGENT_PK, "
" CLASS_AGENT_PK, PASS_FLAG, ATTEND_VALID_FLAG, "
" BOOK_ISBN, CHANGE_STATE, REG_DATE) "
" VALUES ("
" HRDREMOTE.SEQ_ATTEND_HIST.NEXTVAL,"
" :OLD.USERID,"
" :OLD.CNO,"
" :OLD.CATE_UID,"
" CASE WHEN TO_NUMBER( V_MAX_MINUTES )*60 >= :OLD.SEC THEN 0 "
" "
" WHEN TO_NUMBER( V_MAX_MINUTES )*60 < :OLD.SEC THEN 1"
" ELSE 0"
" END,"
" '1',"
" NULL,"
" 'D',"
" SYSDATE "
" ); "
" END IF;"
" EXCEPTION"
" WHEN OTHERS THEN NULL;"
"END;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER "CHORG".TR_AG_USER_LOGIN_HIST "
"AFTER INSERT ON LOGIN_COUNTER"
"REFERENCING OLD AS OLD NEW AS NEW"
"FOR EACH ROW"
"BEGIN"
" IF INSERTING THEN "
" INSERT INTO HRDREMOTE.TB_USER_LOGIN_HIST (seq, user_agent_pk,login_date"
",login_ip ) values ("
" HRDREMOTE.SEQ_USER_LOGIN_HIST.NEXTVAL,"
" :NEW.LC_ID,"
" SYSDATE, "
" :NEW.LC_IP"
" ); "
" END IF;"
"END;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER "CHORG".TR_AG_USER_HIST "
"AFTER INSERT OR DELETE "
"OR UPDATE of mb_name,mb_post,mb_address1,mb_address2,mb_email , mb_tel1, mb"
"_tel2 ON RG4_MEMBER "
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW "
"DECLARE"
" V_ECN_JUMIN VARCHAR(100);"
" V_JUMIN VARCHAR(100);"
"BEGIN"
" /** ¾ÏÈ£ÈµÈ Áֹεî·Ï ¹øÈ£ÀÇ ±¸º°**/"
" IF ( LENGTH(:NEW.MB_JUMIN) > 15 ) THEN"
" V_ECN_JUMIN := :NEW.MB_JUMIN ;"
" V_JUMIN := NULL;"
" ELSE "
" V_ECN_JUMIN := NULL;"
" V_JUMIN := REPLACE( :NEW.MB_JUMIN ,'-','');"
" END IF; "
" "
" /** ȸ¿ø °¡ÀԽà INSERT ¹®Àå**/"
" IF INSERTING THEN"
" INSERT INTO HRDREMOTE.TB_USER_HIST ("
" SEQ, USER_AGENT_PK, USER_NAME, "
" RES_NO, ENC_RES_NO, EMAIL, "
" MOBILE, TEL, POST, "
" CHANGE_STATE, REG_DATE) "
" VALUES ( HRDREMOTE.SEQ_USER_HIST.NEXTVAL,"
" :NEW.MB_ID,"
" :NEW.MB_NAME,"
" V_JUMIN,"
" V_ECN_JUMIN,"
" :NEW.MB_EMAIL,"
" :NEW.MB_TEL2,"
" :NEW.MB_TEL1,"
" :NEW.MB_POST,"
" 'C',"
" SYSDATE );"
" ELSIF DELETING THEN"
" "
" IF ( LENGTH(:OLD.MB_JUMIN) > 15 ) THEN"
" V_ECN_JUMIN := :NEW.MB_JUMIN ;"
" V_JUMIN := NULL;"
" ELSE "
" V_ECN_JUMIN := NULL;"
" V_JUMIN := REPLACE( :NEW.MB_JUMIN ,'-','');"
" END IF; "
" INSERT INTO HRDREMOTE.TB_USER_HIST ("
" SEQ, USER_AGENT_PK, USER_NAME, "
" RES_NO, ENC_RES_NO, EMAIL, "
" MOBILE, TEL, POST, "
" CHANGE_STATE, REG_DATE) "
" VALUES ( HRDREMOTE.SEQ_USER_HIST.NEXTVAL,"
" :OLD.MB_ID,"
" :OLD.MB_NAME,"
" V_JUMIN,"
" V_ECN_JUMIN ,"
" :OLD.MB_EMAIL,"
" :OLD.MB_TEL2,"
" :OLD.MB_TEL1,"
" :OLD.MB_POST,"
" 'D',"
" SYSDATE );"
" ELSIF UPDATING THEN "
" INSERT INTO HRDREMOTE.TB_USER_HIST ("
" SEQ, USER_AGENT_PK, USER_NAME, "
" RES_NO, ENC_RES_NO, EMAIL, "
" MOBILE, TEL, POST, "
" CHANGE_STATE, REG_DATE) "
" VALUES ( HRDREMOTE.SEQ_USER_HIST.NEXTVAL,"
" :NEW.MB_ID,"
" :NEW.MB_NAME,"
" V_JUMIN,"
" V_ECN_JUMIN,"
" :NEW.MB_EMAIL,"
" :NEW.MB_TEL2,"
" :NEW.MB_TEL1,"
" :NEW.MB_POST,"
" 'U',"
" SYSDATE ); "
" END IF;"
" EXCEPTION"
" WHEN OTHERS THEN NULL;"
"END;"
IMP-00041: 경고: 컴파일 경고와 함께 객체가 작성되었습니다.
"CREATE TRIGGER "CHORG".TR_AG_COURSE_HIST "
"AFTER INSERT OR DELETE "
"OR UPDATE of name,STATUS ON CHORG.COURSE"
"REFERENCING NEW AS NEW OLD AS OLD"
"FOR EACH ROW "
"BEGIN "
" IF INSERTING THEN"
" INSERT INTO HRDREMOTE.TB_COURSE_HIST ("
" SEQ, COURSE_AGENT_PK, NAME, "
" TOTAL_EDU_TIME, SIMSA_CODE, VALID_FLAG, "
" POST_COURSE_FLAG, CHANGE_STATE, REG_DATE) "
" VALUES ( "
" HRDREMOTE.SEQ_COURSE_HIST.NEXTVAL,"
" :NEW.NUM,"
" :NEW.NAME,"
" NULL,"
" NULL,"
" DECODE(:NEW.STATUS, '°³¼³',1,0),"
" 0,"
" 'C',"
" SYSDATE );"
" ELSIF UPDATING THEN "
" INSERT INTO HRDREMOTE.TB_COURSE_HIST ("
" SEQ, COURSE_AGENT_PK, NAME, "
" TOTAL_EDU_TIME, SIMSA_CODE, VALID_FLAG, "
" POST_COURSE_FLAG, CHANGE_STATE, REG_DATE) "
" VALUES ( "
" HRDREMOTE.SEQ_COURSE_HIST.NEXTVAL,"
" :NEW.NUM,"
" :NEW.NAME,"
" NULL,"
" NULL,"
" DECODE(:NEW.STATUS, '°³¼³',1,0),"
" 0,"
" 'U',"
" SYSDATE ); "
" ELSIF DELETING THEN "
" INSERT INTO HRDREMOTE.TB_COURSE_HIST ("
" SEQ, COURSE_AGENT_PK, NAME, "
" TOTAL_EDU_TIME, SIMSA_CODE, VALID_FLAG, "
" POST_COURSE_FLAG, CHANGE_STATE, REG_DATE) "
" VALUES ( "
" HRDREMOTE.SEQ_COURSE_HIST.NEXTVAL,"
" :OLD.NUM,"
" :OLD.NAME,"
" NULL,"
" NULL,"
" DECODE(:OLD.STATUS, '°³¼³',1,0),"
" 0,"
" 'D',"
" SYSDATE );"
" "
" END IF;"
" EXCEPTION"
" WHEN OTHERS THEN NULL;"
"END;"
|
