CREATE OR REPLACE PROCEDURE spInnoCallStatInfoIns(
c_StatisticStartTime VARCHAR2,
c_SubCcNo NUMBER
)
AS
v_ErrCode NUMBER(6);
v_ErrMsg VARCHAR2(200);
BEGIN
INSERT INTO tInnoCallStatInfo(AcCode,VdnID) VALUES(v_AcCode,v_VdnID);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
v_ErrCode := SQLCODE;
v_ErrMsg := SUBSTR(SQLERRM, 1, 200);
INSERT INTO t_Prestat_Log(LogDate,ErrorCode,ErrorMsg) VALUES(SYSDATE,v_ErrCode,v_ErrMsg);
COMMIT;
RETURN;
END spInnoCallStatInfoIns;
/
huawei--异常:异常编码,异常信息
最新推荐文章于 2019-11-06 19:59:02 发布