catch the queries causing ORA-01652 (unable to extend temp segment by 128 in tablespace TEMP).

Hello,
 I try to catch the queries causing ORA-01652 (unable to extend temp segment by 128 in tablespace TEMP).

 I use this trigger (failed_to_extend_temp), but when ora-01652 occured,  No rows inserted :-(. 

CREATE OR REPLACE TRIGGER  failed_to_extend_temp
   after servererror on database
declare             
   begin
       if ( is_servererror(1652) )
       then
           insert into Temp_TS_usage values ( 'ora_sysevent = ' || ora_sysevent );
           insert into Temp_TS_usage values ( 'ora_login_user = ' || ora_login_user );
           insert into Temp_TS_usage values ( 'ora_server_error = ' || ora_server_error(1) );
           insert into Temp_TS_usage select 'open cursor ' || rownum || ' ' || sql_text