create procedure StoreError (
  SQL_Error  integer,
  ISAM_Error smallint,
  Error_Text varchar( 255 )
  )

  define i integer;

  begin
    on exception in (- 958 ) -- Temp table <table-name> already exists in session
    end exception with resume;
    create temp table Errors_Table (
      E_SQL  integer,
      E_ISAM smallint,
      E_Text varchar( 255 )
    ) with no log;
  end;

  insert into Errors_Table(E_SQL, E_ISAM, E_Text) values(SQL_Error, ISAM_Error, Error_Text);

  select count(*) into i from Errors_Table;

  raise exception SQL_Error, ISAM_Error, Error_Text||' + '||i||' records in Errors_Table';

  return;
end procedure;
revoke execute on StoreError from public;
update statistics for procedure StoreError;

create table testtab (
  i serial,
  j varchar( 16 )
);
revoke all on testtab from public;

create view testvw(a, b) as select i, j from testtab;
grant select, insert, update, delete on testvw to public;

create procedure TestTrigProc (
  f1 like testtab.i,
  f2 like testtab.j
  )

  execute procedure StoreError(- 746 ,  0 , 'test');

  return;
end procedure;
revoke execute on TestTrigProc from public;
update statistics for procedure TestTrigProc;

create trigger test_trig instead of update on testvw
  referencing new as n old as o
  for each row
  (execute procedure TestTrigProc(o.a, n.b));


insert into testvw(a, b) values( 1 ,'a');
update testvw set b='b';
update testvw set b='c';
select * from Errors_Table;

--cleanup
drop trigger test_trig;
drop procedure TestTrigProc;
drop view testvw;
drop table testtab;
drop procedure StoreError;

Command line sql-crawler v0. 18 /w32, by Alexander "Falcon" Kryzhanovsky.
Successfully connected to test as user informix.
Procedure successfully created.
Privilege successfully revoked.
Statistics successfully updated.
Table successfully created.
Privilege successfully revoked.
View successfully created.
Privilege successfully granted.
Procedure successfully created.
Privilege successfully revoked.
Statistics successfully updated.
Trigger successfully created.
 1  rows were inserted.
HY000:- 746 :[Informix][Informix ODBC Driver][Informix]test +  1  records in Errors_Table
HY000:- 746 :[Informix][Informix ODBC Driver][Informix]test +  1  records in Errors_Table
42S02:- 206 :[Informix][Informix ODBC Driver][Informix]The specified table (errors_table) is not in the database.
ISAM error:- 111 
Trigger successfully dropped.
Procedure successfully dropped.
View successfully dropped.
Table successfully dropped.
Procedure successfully dropped.