双11狂欢大促

盲盒赢 定制羽绒服

开启惊喜盲盒,抽取你的专属好礼

— 惊喜奖品抢先看 —

這個觸發器為什么不能觸發

girl5201314 girl5201314 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
CREATE OR REPLACE TRIGGER EF_STANDARD_WORK_T
AFTER INSERT OR UPDATE of standard_work_time ON EF_STANDARD_WORK_HOURS
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
WHEN (NEW.GROUP_ID IN (18,19,23,25,27))
DECLARE
Partno varchar(20);
standard_time number(8);
CURSOR C_partno(p_model varchar,ss varchar) is select PART_NO from inv_pn where model=trim(p_model) and SUBSTR (part_no, 1, 2)=trim(ss);
BEGIN
if :new.group_id in (18,19,23) then
select sum(standard_work_time) into standard_time from ef_standard_work_hours where model=:new.model and group_id in (18,19,23);
OPEN c_partno(:new.model,'70');
fetch c_partno into partno;
while c_partno%found
loop
insert into ef_standard_work values (ERP_STANDARD_WORK_sequence.nextval,:new.model,partno,standard_time,3,sysdate,sysdate,0);
fetch c_partno into partno;
end loop;
close c_partno;
else
begin
select sum(standard_work_time) into standard_time from ef_standard_work_hours where model=:new.model and group_id in (25,27);
OPEN c_partno(:new.model,'95');
fetch c_partno into partno;
while c_partno%found
loop
insert into ef_standard_work values (ERP_STANDARD_WORK_sequence.nextval,:new.model,partno,standard_time,3,sysdate,sysdate,0);
fetch c_partno into partno;
end loop;
close c_partno;
end;
end if;

EXCEPTION
WHEN OTHERS THEN
null;
END;



...全文

相关推荐

评论 3
收藏 已收藏
分享
返回顶部
girl5201314
基础和管理 17,379 成员 95,111 内容