oracle存储过程里动态执行SQL

……

--当传入学习中心编号时
  IF vSpotCode is not null THEN
     vWhere:=vWhere || ' AND ass.SpotCode=' || vSpotCode;
  END IF;
  --当传入学生层次编号时
  IF vLevelCode is not null THEN
     vWhere:=vWhere || ' AND ass.LevelCode=' || vLevelCode;
  END IF;
  --当传入专业编号时
  IF vSpecCode is not null THEN
     vWhere:=vWhere || ' AND ass.SpecCode=' || vSpecCode;
  END IF;

……

 execute immediate 'update thesisapplyinfo TAI set TAI.StudyState=105 where TAI.Studentid in
            (select ass.userid from all_studentinfo ass where ass.speccode = A.SPECCODE ' || vWhere || ')';

……