求救一简单触发器：表A中插入或更新一个条记录时根据表A与表B中关联字段更新表B中相应的字段。

[saintKnight]

表A
F1 F2
表B
F1 F2
写的触发器如下，执行时报错：
CREATE OR REPLACE TRIGGER trgiName
BEFORE INSERT OR UPDATE
OF tableA.F2
ON tableA
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
begin
IF INSERTING THEN
update tableB
set tableB.F2=:NEW.F2
where tableB.F1= :NEW.F1;
ELSE
update tableB
set tableB.F2=:NEW.F2
where tableB.F1= :OLD.F1;
end;

[armu80830]

CREATE OR REPLACE TRIGGER trgiName
AFTER INSERT OR UPDATE
OF tableA.F2
ON tableA
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
begin
IF INSERTING THEN
update tableB
set F2=:NEW.F2
where F1= :NEW.F1;
ELSE
update tableB
set F2=:NEW.F2
where F1= :OLD.F1;
end;
/

[saintKnight]

我的触发器中也有“/”，漏写了，但也不行！

[saintKnight]

我也试过将Before改为After，也不行，总是提示“出现；符号在需要下列情况之一时：if”

[beckhambobo]

CREATE OR REPLACE TRIGGER trgiName
BEFORE INSERT OR UPDATE
OF tableA.F2
ON tableA
FOR EACH ROW
begin
IF INSERTING THEN
update tableB
set tableB.F2=:NEW.F2
where tableB.F1= :NEW.F1;
ELSE
update tableB
set tableB.F2=:NEW.F2
where tableB.F1= :OLD.F1;
end if;
end;
/