oracle中if是不可用的吗,求助帖！oracle触发器if中不支持子查询怎么处理

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

create or replace trigger "DEPART_ADD_TRIGGER"

after insert on bd_deptdoc for each row

begin

if :new.def15=*Y* and :new.pk_corp in (select pk_corp from bd_corp where pk_corp=*1553* or fathercorp=*1553*) then

insert into unit_change(PK_unit_change,comcode,comcname,comshortname,addresscname,postcode,phonenumber,uppercomcode,comflag,comlevel,branchtype,

upperpath,comcodecirc,licenseno,comkind,newcomcode,validdate,invaliddate,validstatus_hr,id_hr,level_hr,updatetime)

values(change_seq.nextval,:new.remcode,:new.def9,:new.deptname,:new.addr,:new.memo,:new.phone,:new.remcode,*1*,:new.def1,:new.pk_corp,

:new.pk_deptdoc,:new.def10,:new.def3,:new.def12,:new.remcode,:new.createdate,:new.canceldate,1,:new.pk_deptdoc,:new.def1,to_char(sysdate,*yyyy-mm-dd hh24:mi:ss*));

elsif :new.def15=*N* and :new.pk_corp in (select pk_corp from bd_corp where pk_corp=*1553* or fathercorp=*1553*) then

insert into unit_change(PK_unit_change,comcode,comcname,comshortname,uppercomcode,postcode,comflag,

upperpath,newcomcode,validdate,invaliddate,validstatus_hr,id_hr,updatetime)

values(change_seq.nextval,:new.remcode,:new.deptname,:new.deptname,:new.remcode,:new.memo,*2*,

:new.pk_deptdoc,:new.remcode,:new.createdate,:new.canceldate,1,:new.pk_deptdoc,to_char(sysdate,*yyyy-mm-dd hh24:mi:ss*));

end if;

end;

报错

此上下文中不支持子查询

错误：PLS-00405: 此上下文中不支持子查询

行：4

文本：if :new.def15=*Y* and :new.pk_corp in (select pk_corp from bd_corp where pk_corp=*1553* or fathercorp=*1553*) then

错误：PL/SQL: Statement ignored

行：4

文本：if :new.def15=*Y* and :new.pk_corp in (select pk_corp from bd_corp where pk_corp=*1553* or fathercorp=*1553*) then