oracle触发器加判断条件,oracle触发器where条件失效

Create Or Replace Trigger Hvm_cfg_normalUpdateAfter

after insert or update or delete

on hvm_cfg_normal

for each row

declare

deviceNum number; --判断装置表(device)中是否存在监测装置的个数

begin

if inserting then --新增

insert into test values('','','',:new.objid);

update Hvm_ObjAllSts o set o.devexist=1 where o.sbbm=:new.objid;

elsif deleting then --删除

select count(0) into deviceNum from Hvm_ObjAllSts o where o.sbbm=:old.objid;

if deviceNum<0 then

update Hvm_ObjAllSts o set o.devexist=0 where o.sbbm=:old.objid;

end if;

elsif updating then

select count(0) into deviceNum from Hvm_ObjAllSts o where o.sbbm=:old.objid;

if :old.objid!=:new.objid and deviceNum<0 then

update Hvm_ObjAllSts o set o.devexist=0 where o.sbbm=:old.objid;

update Hvm_ObjAllSts o set o.devexist=1 where o.sbbm=:new.objid;

end if;

end if;

end;

这个是我的触发器，当hvm_cfg_normal表有新增的时候 修改 表Hvm_ObjAllSts 的字段devexist为1。不能修改

insert into test values('','','',:new.objid);

这个语句测试时候得到了objid,当我新增一条记录时在test表中却是看到了这个objid,但是

update Hvm_ObjAllSts o set o.devexist=1 where o.sbbm=:new.objid;

这个语句不能修改Hvm_ObjAllSts表中的devexist。大家帮我看看是什么原因了。谢谢各位了……

作者: snjcaorui

发布时间: 2011-08-11