qq_43100388
qq_43100388
采纳率100%
2019-01-08 12:58 阅读 1.4k

oracle触发器调试时提示触发器/函数不能读它,请问怎么解决?

图片说明图片说明

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;

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    viviliving 回到未来望过去 2019-03-26 17:14

    select je into jezh from p_form0000000088_m where ischeck=1 and ht=:new.ht;
    这句屏蔽掉改成
    jezh:=:old.je或者jezh:=:new.je看你的意思好像要保存老的金额,就是用old即可

    点赞 评论 复制链接分享

相关推荐