how to judge declare param is null on using trigger in Oracle10g? -
i have defined following trigger:
create or replace trigger c_ins_task_insert before insert on c_ins_task each row declare v_yearpaoidold varchar2(255); begin select bsnum v_yearpaoidold t_ins_businessinfo bs bs.pbsnum = :new.cbsnum , bs.permid = :new.permid , rownum =1; if(v_yearpaoidold not null) :new.bsnum := v_yearpaoidold; :new.isstart := '1'; :new.isfinish := '6'; :new.starttime := systimestamp; end if; end;
``` when execute code ,i error .and remove trigger, next picture good,so guess error in if(v_yearpaoidold not null) then
,but don't know how it.
Comments
Post a Comment