这个触发器有时候不执行,问怎么回事
CREATE OR REPLACE TRIGGER "INSERTHMD"
after insert on t_wfcx_clxx for each row
declare
v_new_cyzgzh t_wfcx_clxx.cyzgzh%type;
v_new_wfcx_xm t_wfcx_clxx.jsyxm%type;
v_new_wfcx_sfzh t_wfcx_clxx.jsysfzh%type;
v_new_wfcx_clxxxh t_wfcx_clxx.clxxxh%type;
begin
if :new.cyzgzh is not null then
v_new_cyzgzh:=:new.cyzgzh;
v_new_wfcx_xm :=:new.jsyxm;
v_new_wfcx_sfzh :=:new.jsysfzh;
v_new_wfcx_clxxxh :=:new.clxxxh;
begin
P_INSERTHMD(v_new_cyzgzh,v_new_wfcx_xm,v_new_wfcx_sfzh,v_new_wfcx_clxxxh);
end;end if;
end;
CREATE OR REPLACE TRIGGER "INSERTHMD"
after insert on t_wfcx_clxx for each row
declare
v_new_cyzgzh t_wfcx_clxx.cyzgzh%type;
v_new_wfcx_xm t_wfcx_clxx.jsyxm%type;
v_new_wfcx_sfzh t_wfcx_clxx.jsysfzh%type;
v_new_wfcx_clxxxh t_wfcx_clxx.clxxxh%type;
begin
if :new.cyzgzh is not null then
v_new_cyzgzh:=:new.cyzgzh;
v_new_wfcx_xm :=:new.jsyxm;
v_new_wfcx_sfzh :=:new.jsysfzh;
v_new_wfcx_clxxxh :=:new.clxxxh;
begin
P_INSERTHMD(v_new_cyzgzh,v_new_wfcx_xm,v_new_wfcx_sfzh,v_new_wfcx_clxxxh);
end;end if;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货