Re: Using insert statements in triggers and functions

CREATE OR REPLACE PROCEDURE LOG_ERROR(SQLCODE IN NUMBER,         SQLERRM IN VARCHAR2, BLOCK_NAME IN VARCHAR2, PARAM_VALUES IN VARCHAR2) AS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO SQL_ERROR_LOG(ERROR_TIME, SQLCODE, SQLERRM, BLOCK_NAME, PARAM_VALUES)
        VALUES(SYSDATE, SQLCODE, SQLERRM, BLOCK_NAME, PARAM_VALUES); COMMIT;
END
; Received on Tue Jul 12 2005 - 13:43:30 CDT