數據庫異常處理

return_code NUMBER;
return_sql VARCHAR2(200);

 

EXCEPTION
WHEN OTHERS THEN
return_code := SQLCODE;
return_sql := SQLERRM;
<<Insert_Error_Data>>
ROLLBACK;
INSERT INTO c_error
(timekey, procname, errnum, errmsg)
VALUES
(v_timekey, 'ChangeLiuCheng', return_code, return_sql||v_areaname|| v_PROCESSOPERATIONNAME|| v_nodestack|| v_REWORKSTATE|| v_REWORKNODEID);

COMMIT;