오라클 프로시저에서 멀티 인설트를 하려고 하면 이셉션이 계속나는데 무엇이 문제인가요? 디버깅을 하려고 해봤지만 그냥 저부분자체를 건너뛰어버리고 디버깅됩니다. SQL로 INSERT ALL 테스트를 해봤을때는 문제가 없는데 PLSQL로 작성하고 테스트 했을떄는 계속 에러가 나네요. 프로시저로 작업하는게 처음이라서 많이 벅차네요 도와주세요 ^^ BEGIN INSERT ALL -- 첫번째 입력 INTO TNMC_CREMATERESERVEINFO ( FAID , RESERVEYMD , RESERVESEQ , RESERVENUM , COMPANY , DEADYMD , DEADTIME , REMARK , RESERVETYPEDIVCD , RECEIVEPERSON , RECEIVEYMD , RECEIVETIME , RESERVEMETHODCD , IPADDRESS , DEADPLACEDIVCD , DEADREASONDIVCD , BONEDIVCD , APPLICANTDEADCONNECTCD , APPLICANTDEADCONNECTDESC , APPLICANTEMAIL , JURISDICTIONDIVCD , SMSAGREEYN , FIRSTRESERVEYMD , FIRSTRESERVESEQ , FIRSTRESERVENUM , FIRSTRESERVEORDER , DEADSTATEDIVCD , APPLICANTSTATEDIVCD , DEADCONTACTNUM , APPLICANTCONTACTNUM , BIRTHMONTHS , PREVRESERVEYMD , PREVRESERVESEQ , PREVRESERVENUM , DEADINFOID , JUMINNOYN , INSDIV , CREATE_USER , CREATE_DATE , UPDATE_USER , UPDATE_DATE , BuryingYN , DEADDOCUMENTNO , DEADDOCUEQUIPNM ) VALUES ( P_FAID , P_RESERVEYMD , P_RESERVESEQ , V_RESERVENUM , P_COMPANY , P_DEADYMD , P_DEADTIME , P_REMARK , P_RESERVETYPEDIVCD , P_RECEIVEPERSON , TO_CHAR(SYSDATE,'YYYYMMDD') , TO_CHAR(SYSDATE,'HH24MISS') , 'TMC0400001' , P_IPADDRESS , P_DEADPLACEDIVCD , P_DEADREASONDIVCD , P_BONEDIVCD , P_APPLICANTDEADCONNECTCD , P_APPLICANTDEADCONNECTDESC , P_APPLICANTEMAIL , P_JURISDICTIONDIVCD , P_SMSAGREEYN , P_RESERVEYMD , P_RESERVESEQ , V_RESERVENUM , V_FIRSTRESERVEORDER , P_DEADSTATEDIVCD , P_APPLICANTSTATEDIVCD , '' , '' , P_BIRTHMONTHS , P_RESERVEYMD , P_RESERVESEQ , V_RESERVENUM , P_DEADINFOID , V_JUMINNOYN , 'I' , P_UPDATE_USER , SYSDATE , P_UPDATE_USER , SYSDATE , P_BURYINGYN , SUBSTRB(P_DEADDOCUMENTNO,1,100) , SUBSTRB(P_DEADDOCUEQUIPNM,1,100) ) -- 두번째 입력 INTO TNMC_CREMATERESERVEINFO ( FAID , RESERVEYMD , RESERVESEQ , RESERVENUM , COMPANY , DEADYMD , DEADTIME , REMARK , RESERVETYPEDIVCD , RECEIVEPERSON , RECEIVEYMD , RECEIVETIME , RESERVEMETHODCD , IPADDRESS , DEADPLACEDIVCD , DEADREASONDIVCD , BONEDIVCD , APPLICANTDEADCONNECTCD , APPLICANTDEADCONNECTDESC , APPLICANTEMAIL , JURISDICTIONDIVCD , SMSAGREEYN , FIRSTRESERVEYMD , FIRSTRESERVESEQ , FIRSTRESERVENUM , FIRSTRESERVEORDER , DEADSTATEDIVCD , APPLICANTSTATEDIVCD , DEADCONTACTNUM , APPLICANTCONTACTNUM , BIRTHMONTHS , PREVRESERVEYMD , PREVRESERVESEQ , PREVRESERVENUM , DEADINFOID , JUMINNOYN , SURVEYYN , INSDIV , CREATE_USER , CREATE_DATE , UPDATE_USER , UPDATE_DATE , BuryingYN , RESERVEREFKEY , DEADDOCUMENTNO , DEADDOCUEQUIPNM ) VALUES ( P_FAID , P_RESERVEYMD , P_RESERVESEQ , V_RESERVENUM , P_COMPANY , P_DEADYMD , P_DEADTIME , P_REMARK , P_RESERVETYPEDIVCD , P_RECEIVEPERSON , TO_CHAR(SYSDATE,'YYYYMMDD') , TO_CHAR(SYSDATE,'HH24MISS') , 'TMC0400001' , P_IPADDRESS , P_DEADPLACEDIVCD , P_DEADREASONDIVCD , P_BONEDIVCD , P_APPLICANTDEADCONNECTCD , P_APPLICANTDEADCONNECTDESC , P_APPLICANTEMAIL , P_JURISDICTIONDIVCD , P_SMSAGREEYN , P_RESERVEYMD , P_RESERVESEQ , V_RESERVENUM , V_FIRSTRESERVEORDER , P_DEADSTATEDIVCD , P_APPLICANTSTATEDIVCD , '' , '' , P_BIRTHMONTHS , P_RESERVEYMD , P_RESERVESEQ , V_RESERVENUM , P_DEADINFOID , V_JUMINNOYN , P_SURVEYYN , 'I' , P_UPDATE_USER , SYSDATE , P_UPDATE_USER , SYSDATE , P_BURYINGYN , V_RESERVEREFKEY01 , SUBSTRB(P_DEADDOCUMENTNO,1,100) , SUBSTRB(P_DEADDOCUEQUIPNM,1,100) ) SELECT * FROM DUAL; EXCEPTION ROLLBACK; -- 예외상황 발생시 다시 INSERT 하는 로직이 들어있는 부분입니다. END;