在线等，触发器不能操作它本身的表？

[tjm1]

CREATE OR REPLACE TRIGGER tri_del_depre
before delete
on dev_depre
for each row

declare
ls_max_month varchar2(6);

begin
select max(depre_mon) into ls_max_month from dev_depre;
end;

执行后报错：触发器/函数不能读

[tjm1]

我想操作怎么办？oracle不支持?

[tjm1]

ding a

[CodeMagic]

CREATE OR REPLACE TRIGGER tri_del_depre before delete on dev_depre
declare
ls_max_month varchar2(6);
begin
select max(depre_mon) into ls_max_month from dev_depre;
end;

[ORARichard]

用表级触发，去掉for each row

[tjm1]

3楼的前辈能否解释一下为啥把for each给去掉了?

[GerryYang]

去掉for each row
试试

[ORARichard]

for each row 表示行级触发，在你delete记录时，表在行上会发生变化，这时取和行相关的数据时是不正确的。也是ORACLE中不允许的