create or replace trigger col_hist
	before insert or update or delete
	on test for each row
begin

declare
 sqltext varchar2( 1000 );
    cursor_name INTEGER;
         rows_processed INTEGER;
   сursor c1 is select col,tabl from dir where upper(tabl)='TEST';
   cursor c2 is select * from dual;
begin
open c2;
    for i in c1 LOOP
           if UPDATING(i.col) then

sqltext:='insert into col_history values(to_date('''||SYSDATE||''',''dd.mm.yy hh24:mi:ss''),''UPDATE'','||:NEW.i.col||','''||i.col||''','''||ora_login_user||''',''refref'','''||i.tabl||''')';


    cursor_name := dbms_sql.open_cursor;
    DBMS_SQL.PARSE(cursor_name,sqltext,dbms_sql.native);
    rows_processed := dbms_sql.execute(cursor_name);
    DBMS_SQL.close_cursor(cursor_name);

end IF;
end LOOP;
close c2;
end;
END;