END IF;
COMMIT;
END IF;
<<TO_NEXT>>
null;
--begin yinlei
BEGIN
IF IS_EXCEPTION_CODE <> 0 THEN
select to_char(sysdate,'yymmddhhmi')||lpad(to_char(SEQ_ERP_LOG.nextval),14,'0') INTO C_SEQ from dual;
INSERT INTO INT_ERP_LOG(LOGID,INTERFACENAME,INTIME,REFERENCE_NUM,STATUS,ERR_MESSAGE)VALUES (C_SEQ, 'INT_ERP_PO_CREATE', SYSDATE, v_REFERENCE_NUM, '-1', v_ERROR_DESCRIPTION);
--insert into main table
存储过程8
最新推荐文章于 2018-11-05 11:56:00 发布