CREATE OR REPLACE PROCEDURE "LOG_ERROR"
Log_error(error_msg IN VARCHAR2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
Insert into Error_log values ( systimestamp,error_msg);
COMMIT;
END;
end;//----
2,4行老是报出问题呀,请大家帮着看一下,谢谢了
Log_error(error_msg IN VARCHAR2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
Insert into Error_log values ( systimestamp,error_msg);
COMMIT;
END;
end;//----
2,4行老是报出问题呀,请大家帮着看一下,谢谢了
CREATE OR REPLACE PROCEDURE LOG_ERROR(ERROR_MSG IN VARCHAR2) IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO ERROR_LOG VALUES (SYSTIMESTAMP, ERROR_MSG);
COMMIT;
END;
/
去掉一个试试
(error_msg IN VARCHAR2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
Insert into Error_log values ( systimestamp,error_msg);
COMMIT;
END LOG_ERROR;