……
--当传入学习中心编号时
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 || ')';
……