oracle存储过程中游标的问题
oracle存储过程中一游标定义为:
CURSOR MANU_BOM_ITEM IS
SELECT vcAspID,vcGoodsID,vcGoodsName,vcChildBomID,vcBomItemHelpCode FROM TB_MANU_BOM_ITEM WHERE vcBomID = v_vcBomID AND vcAspID=v_aspID;
................
open MANU_BOM_ITEM ;
fetch MANU_BOM_ITEM into v_vcAspID,v_vcGoodsID,v_vcGoodsName,v_vcChildBomID,v_vcBomItemHelpCode;
while MANU_BOM_ITEM%found loop
...............
end loop;
close MANU_BOM_ITEM ;
..............
我在pl/sql 中测试时,执行到while MANU_BOM_ITEM%found loop后,就直接执行close MANU_BOM_ITEM ,也就是游标没有记录集返回;但我在sql窗口中直接执行游标里的select语句:
SELECT vcAspID,vcGoodsID,vcGoodsName,vcChildBomID,vcBomItemHelpCode FROM TB_MANU_BOM_ITEM WHERE vcBomID = v_vcBomID AND vcAspID=v_aspID;
是有记录集的.
真是奇怪,哪位高手指点下?