create or replace trigger mon_plan
after update on p_form0000000088_m for each row
declare
htbh p_form0000000088_m.ht%type;
jezh NUMBER(18,6);
begin
select code into htbh from cnt_m where bill_no=:new.ht;
select je into jezh from p_form0000000088_m where ischeck=1 and ht=:new.ht;
update zj_planapp_d set year_bal_amt=jezh where cnt_code=htbh;
end;
select je into jezh from p_form0000000088_m where ischeck=1 and ht=:new.ht;
这句屏蔽掉改成
jezh:=:old.je或者jezh:=:new.je看你的意思好像要保存老的金额,就是用old即可