strSql:='select * from S_ModelSystem where (ManageFlag=''0'')and(version>='||oldVersion||')';
改成
strSql:='select * from S_ModelSystem where (ManageFlag='''||0||''')and(version>='||oldVersion||')';
改成
strSql:='select * from S_ModelSystem where (ManageFlag='''||0||''')and(version>='||oldVersion||')';
select * from S_ModelSystem where (ManageFlag='0')and(version>=36)我把这句拿到SqlPlus中执行,返回多条记录。我甚至直接用select * from S_ModelSystem ,但是问题依旧!
loop
exit when cModelSystem%notfound
...
end loop;
loop
fetch .... into ....;
exit when cModelSystem%notfound;
...
end loop;
记录号rowcount开始为0,然后依次递增.