CREATE OR REPLACE TRIGGER TBL_ALERTS AFTER INSERT
ON ALERTS for each row
DECLARE
v_LRQAID NUMBER(10);
v_LRULEID NUMBER(10);
v_LID NUMBER(10);
v_if_exists INTEGER;
BEGIN
v_LRQAID := :new.LRQAID;
insert into RiskCashOutAlert_test values (v_LRQAID);
select LRULEID into v_LRULEID from RqPortAssign r where r.lid=v_LRQAID;
select LID into v_LID from ruleque t where t.lqueueid=v_LRULEID ; -- no data find select count(*) into v_if_exists from cust_actioncode c where c.ntype=15 and c.scodevalue=v_LID;
if v_if_exists>0 then
insert into RiskCashOutAlert_test values (:new.ACTION_LEVEL_KEY);
end if;
END;你好,这是我的触发器,select LID into v_LID 这句话可能会没数据,请问怎么增加好?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货