This trigger does not perform, sometimes ask what
The CREATE OR REPLACE the 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;
The 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;
The begin
P_INSERTHMD (v_new_cyzgzh v_new_wfcx_xm, v_new_wfcx_sfzh v_new_wfcx_clxxxh);
end;

end if;
end;

CodePudding user response:

this trigger does not perform, sometimes ask what


What time?

CodePudding user response:

Insert failed? P_INSERTHMD this process have internal error logging, insert the table fields of constraints,

CodePudding user response:

"Sometimes does not perform", should be the program logic problem, suggestion.