CREATE TRIGGER a_update BEFORE UPDATE OF a ON a REFERENCING OLD AS old_value NEW AS new_value FOR EACH ROW BEGIN UPDATE b SET b.b=:new_value.a WHERE b.id = :new_value.id; END;
create trigger a_update_trig before update of a on a for each row begin --:new.id:=5; insert into a(a,id)values(5,:new.id); commit; update b set b=5 where id=:new.id; commit; end a_update_trig;
create trigger a_update_trig before update of a on a for each row begin update b set b=:new.a where id=:new.id; commit; end a_update_trig;
CREATE OR REPLACE TRIGGER TRG_A_UPDATE BEFORE UPDATE ON A FOR EACH ROW DECLARE BEGIN UPDATE B SET B.B=:NEW.A WHERE B.ID=:NEW.ID END;
在运行update a set a=5时 系统提示 error ORA-04098:触发器'SCOTT.A_UPDATE_TRIG'无效且未通过重新验证 OK CANCEL HELP
在运行update a set a=5时 系统提示 error ORA-04098:触发器'SCOTT.A_UPDATE_TRIG'无效且未通过重新验证 OK CANCEL HELP
BEFORE UPDATE OF a ON a
REFERENCING OLD AS old_value NEW AS new_value
FOR EACH ROW
BEGIN
UPDATE b SET b.b=:new_value.a WHERE b.id = :new_value.id;
END;
before update of a on a
for each row
begin
--:new.id:=5;
insert into a(a,id)values(5,:new.id);
commit;
update b set b=5 where id=:new.id;
commit;
end a_update_trig;
before update of a on a
for each row
begin
update b set b=:new.a where id=:new.id;
commit;
end a_update_trig;
BEFORE UPDATE
ON A
FOR EACH ROW
DECLARE BEGIN
UPDATE B SET B.B=:NEW.A WHERE B.ID=:NEW.ID
END;
error
ORA-04098:触发器'SCOTT.A_UPDATE_TRIG'无效且未通过重新验证
OK CANCEL HELP
在运行update a set a=5时 系统提示
error
ORA-04098:触发器'SCOTT.A_UPDATE_TRIG'无效且未通过重新验证
OK CANCEL HELP