Question

建立触发器出现Warning: Trigger created with compilation errors

if inserting Then if :new.stutypeid='01' or :new.stutypeid='02' or :new.stutypeid='89' or :new.stutypeid='90' or :new.stutypeid='97' or :new.stutypeid='98' then cursor cc is select m.zydm from majorbase m where m.ismajor='0' open cc; loop fetch cc into zydm; if zydm=:new.zydm then insert into school_major values(:new.stutypeid,:new.schoolid,:new.majorid,:new.isaccept); end if; end loop; end if; close cc; end if; Warning: Trigger created with compilation errors

Answer 1

把游标定义到begin之前