create or replace trigger av_trace_trigger
after insert
on av_action
for each row
begin 
        delete from av_trace; 
	if :new.type = 'up' then
	   uptracing( :new.id);
        else
	   downtracing( :new.id);
        end if;
end;
/