CREATE TRIGGER ddd AFTER INSERT OR
DELETE
ON "AUTHS"
FOR EACH ROW --记录级角发器
begin
if updating then --如果是修改记录则执行
update article
set author_code = :new.author_code
where author_code = :old.author_code;
else
delete from article where author_code =:old.author_code;
end if;
end ddd;
CREATE TRIGGER ddd AFTER INSERT OR
*
ERROR 位于第 1 行:
ORA-04089: 无法对 SYS 所有的对象创建触发器
DELETE
ON "AUTHS"
FOR EACH ROW --记录级角发器
begin
if updating then --如果是修改记录则执行
update article
set author_code = :new.author_code
where author_code = :old.author_code;
else
delete from article where author_code =:old.author_code;
end if;
end ddd;
CREATE TRIGGER ddd AFTER INSERT OR
*
ERROR 位于第 1 行:
ORA-04089: 无法对 SYS 所有的对象创建触发器
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货