有没有办法在Oracle g中记录所有失败的sql语句

ALTER SESSION SET EVENTS '10046 trace name context forever, level action';

CREATE TABLE failed_sql_statements (
    id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY,
    sql_text CLOB,
    error_message CLOB,
    timestamp TIMESTAMP
);

CREATE OR REPLACE PROCEDURE handle_failed_sql (
    p_sql_text CLOB,
    p_error_message CLOB
) AS
BEGIN
    INSERT INTO failed_sql_statements (sql_text, error_message, timestamp)
    VALUES (p_sql_text, p_error_message, SYSTIMESTAMP);
END;

CREATE OR REPLACE TRIGGER failed_sql_trigger
AFTER SERVERERROR ON DATABASE
DECLARE
    v_sql_text CLOB;
    v_error_message CLOB;
BEGIN
    SELECT SQL_TEXT, ERROR_MESSAGE
    INTO v_sql_text, v_error_message
    FROM SYS.V_$SQL_PLAN_STATISTICS_ALL
    WHERE SQL_ID = SYS_CONTEXT('USERENV', 'CURRENT_SQL_ID');

    handle_failed_sql(v_sql_text, v_error_message);
END;

SELECT * FROM nonexistent_table;

SELECT * FROM failed_sql_statements;