请问如下写法怎么不对?
create or replace trigger update_AA1
before insert or update or delete on tb_power.AA1
REFERENCING old AS old new AS new
FOR EACH rowbegin
if :new.l_name <> :old.l_name then
update AA1
set L_TYPE = '00000',L_NAME = '11'
where L_NAME <> :new.L_NAME;
end if;
end ;总提示说:表AA1发生了变化,触发器/函数不能读.
create or replace trigger update_AA1
before insert or update or delete on tb_power.AA1
REFERENCING old AS old new AS new
FOR EACH rowbegin
if :new.l_name <> :old.l_name then
update AA1
set L_TYPE = '00000',L_NAME = '11'
where L_NAME <> :new.L_NAME;
end if;
end ;总提示说:表AA1发生了变化,触发器/函数不能读.
before update on tb_power.AA1
REFERENCING old AS old new AS new
FOR EACH rowbegin
update AA1
set L_TYPE = '00000',L_NAME = '11'
where :new.l_name <> :old.l_name ;
end对新增和删除的那条记录来说,如何区分new和old?
因此要对insert和delete另写触发器,或在其它表“看过来”。