存储过程2
V_PROC_STATUS INT_ERP_PO_INFO.PROC_STATUS%TYPE;V_SQL VARCHAR2(1024);
V_P_REQ_LINES_TBL INT_POS_SR.P_REQ_LINES_TBL@ERP;
V_INFOCOUNT NUMBER;
V_RESULT_FLAG NUMBER;
V_ERROR_DESCRIPTION VARCHAR2(512);
V_CRM_ORG_ID VARCHAR2(32);
EXCEPTION_MSG VARCHAR2(512);
--query reference_num
--add by yinlei 0：ok -1 erp -2 crm -3 unknown
IS_EXCEPTION_CODE NUMBER := 0;
C_SEQ VARCHAR2(32);
页:
[1]