insert or update in row level after insert or update trigger

[ahmet_sinav]

hi all;
how can i insert or update in the after insert or update trigger fro the same table. when i try this the trigger is firing again fire in trigger.

for example :
trigger for tbl_x after insert or update for each row;
create or replace function fooo();
begin
update tbl_x set fld1='1';
insert into tbl_x set fld2='3';
return null;
end;

Note : The synntax may be wrong. i only want that how can i make this?

 

[rski]

When u use triggers u have can use two additionals tables OLD and NEW inside functions. Maybe try to modify them. If u use after i think u should modify NEW and then return NEW.

 

[ahmet_sinav]

tnks
i solve the problem as you say.
Regards.