create table ERROR_LOG
(
  id       NUMBER,
  username VARCHAR2(30),
  errcode  INTEGER,
  seq      INTEGER,
  tmstmp   TIMESTAMP(6),
  msg      VARCHAR2(4000),
  sql_text CLOB
)
/
create sequence err_seq
/
create or replace trigger trg_error_logging
after servererror
on schema
declare
   v_id       number   := err_seq.nextval();
   v_tmstmp   timestamp:= systimestamp;
   n          int;
   sql_text   dbms_standard.ora_name_list_t;
   v_sql_text clob;
begin
   v_sql_text:=null;
   n := ora_sql_txt(sql_text);
   for i in 1..n loop
      v_sql_text := v_sql_text || sql_text(i);
   end loop;

   for i in 1.. ora_server_error_depth
   loop
      if i=1 then
         insert into error_log(id,seq,tmstmp,username,errcode,msg,sql_text)
            values( v_id, i, v_tmstmp, user, ora_server_error(i), ora_server_error_msg(i), v_sql_text);
      else
         insert into error_log(id,seq,tmstmp,username,errcode,msg)
            values( v_id, i, v_tmstmp, user, ora_server_error(i), ora_server_error_msg(i) );
      end if;
   end loop;
   commit;
END;
/
-- если все без ошибок, то включаем:
alter trigger trg_error_logging enable
/

SQL> create table ERROR_LOG
  2  (
  3    id       NUMBER,
  4    username VARCHAR2(30),
  5    errcode  INTEGER,
  6    seq      INTEGER,
  7    tmstmp   TIMESTAMP(6),
  8    msg      VARCHAR2(4000),
  9    sql_text CLOB
 10  )
 11  /

Table created.

SQL> create sequence err_seq
  2  /

Sequence created.

SQL> create or replace trigger trg_error_logging
  2  after servererror
  3  on schema
  4  declare
  5     v_id       number   := err_seq.nextval();
  6     v_tmstmp   timestamp:= systimestamp;
  7     n          int;
  8     sql_text   dbms_standard.ora_name_list_t;
  9     v_sql_text clob;
 10  begin
 11     v_sql_text:=null;
 12     n := ora_sql_txt(sql_text);
 13     for i in 1..n loop
 14        v_sql_text := v_sql_text || sql_text(i);
 15     end loop;
 16
 17     for i in 1.. ora_server_error_depth
 18     loop
 19        if i=1 then
 20           insert into error_log(id,seq,tmstmp,username,errcode,msg,sql_text)
 21              values( v_id, i, v_tmstmp, user, ora_server_error(i), ora_server_error_msg(i), v_sql_text);
 22        else
 23           insert into error_log(id,seq,tmstmp,username,errcode,msg)
 24              values( v_id, i, v_tmstmp, user, ora_server_error(i), ora_server_error_msg(i) );
 25        end if;
 26     end loop;
 27     commit;
 28  END;
 29  /

Trigger created.

SQL> alter trigger trg_error_logging enable
  2  /

Trigger altered.

SQL> set serverout on;
SQL> begin
  2      declare
  3          i int:=0;
  4      begin
  5          i:=1/i;
  6      exception when others then
  7          dbms_output.put_line('e1');
  8          raise;
  9      end;
 10  exception when others then
 11      dbms_output.put_line('e2');
 12      raise;
 13  end;
 14  /
e1
e2
>>>begin
*
ERROR at line 1:
ORA-01476: divisor is equal to zero
ORA-06512: at line 12
<<<

SQL> col msg for a120;
SQL> select id,seq,errcode,msg from error_log;

        ID        SEQ    ERRCODE MSG
---------- ---------- ---------- ------------------------------------------------------------------------------------------------------------------------
         1          1       1476 ORA-01476: divisor is equal to zero
         1          2       6512 ORA-06512: at line 12

2 rows selected.

SQL> col msg clear;

create table ERROR_LOG
(
  id       NUMBER,
  username VARCHAR2(30),
  errcode  INTEGER,
  seq      INTEGER,
  tmstmp   TIMESTAMP(6),
  msg      VARCHAR2(4000),
  sql_text CLOB
)
/
create sequence err_seq
/
create or replace trigger trg_error_logging
after servererror
on schema
disabled
declare
   v_id       number   := err_seq.nextval();
   v_tmstmp   timestamp:= systimestamp;
   n          int;
   sql_text   dbms_standard.ora_name_list_t;
   v_sql_text clob;
begin
   v_sql_text:=null;
   n := ora_sql_txt(sql_text);
   for i in 1..n loop
      v_sql_text := v_sql_text || sql_text(i);
   end loop;

   for i in 1.. ora_server_error_depth
   loop
      if i=1 then
         insert into error_log(id,seq,tmstmp,username,errcode,msg,sql_text)
            values( v_id, i, v_tmstmp, user, ora_server_error(i), ora_server_error_msg(i), v_sql_text);
      else
         insert into error_log(id,seq,tmstmp,username,errcode,msg)
            values( v_id, i, v_tmstmp, user, ora_server_error(i), ora_server_error_msg(i) );
      end if;
   end loop;
   commit;
END;
/
-- если все без ошибок, то включаем:
alter trigger trg_error_logging enable
/