Trigger after insert

From: Sylvain <sylvain.ricaud_at_wunderman-i.com>
Date: 21 Aug 2003 06:04:38 -0700
Message-ID: <4091e6a4.0308210504.6d881824@posting.google.com>

Hi,

i got 2 tables which are linked thanks to a database link. those tables have the same fields.

everytime data are inserted in the first one, i'd like those data to be inserted in the second table.

i've created the following trigger :

CREATE TRIGGER "DBUSER".INSERT_DATA AFTER INSERT ON "DBUSER"."TABLE1" REFERENCING OLD AS old NEW AS new
FOR EACH ROW
begin
insert into table2_at_dblink(field1,field2,field3,field4) values (:new.field1,:new.field2,:new.field3,:new.field4); end;

but that doesn't work.
i got the following error :
ORA-04098: trigger 'INSERT_DATA' is invalid and failed re-validation

Does anybody have an idea ?

Thanks Received on Thu Aug 21 2003 - 08:04:38 CDT