ops$tkyte%ORA10GR2> create table t( id number, seq number, msg varchar2(4000) );

Table created.

ops$tkyte%ORA10GR2> create sequence s;

Sequence created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> create or replace trigger failed_to_extend_temp
  2  after servererror on database
  3  declare
  4      l_sql_text ora_name_list_t;
  5      l_n        number;
  6  begin
  7      if ( is_servererror(942) )
  8      then
  9          insert into t values ( s.nextval, 1, 'ora_sysevent = ' || ora_sysevent );
 10          insert into t values ( s.currval, 2, 'ora_login_user = ' || ora_login_user );
 11          insert into t values ( s.currval, 3, 'ora_server_error = ' || ora_server_error(1) );
 12          l_n := ora_sql_txt( l_sql_text );
 13          for i in 1 .. l_n
 14          loop
 15             insert into t values ( s.currval, 3+i, 'l_sql_text(' || i || ') = ' || l_sql_text(i) );
 16          end loop;
 17      end if;
 18  end;
 19  /

Trigger created.

ops$tkyte%ORA10GR2> select * from does_not_exist;
select * from does_not_exist
              *
ERROR at line 1:
ORA-00942: table or view does not exist


ops$tkyte%ORA10GR2> select * from t;

        ID        SEQ MSG
---------- ---------- ------------------------------
         1          1 ora_sysevent = SERVERERROR
         1          2 ora_login_user = OPS$TKYTE
         1          3 ora_server_error = 942
         1          4 l_sql_text(1) = select * from
                      does_not_exist