db2存储过程中for循环问题
高新娥 2011-01-17 03:31:45 我在存储过程中使用for循环,但是只执行一次就不在执行了,也就是没有循环,以下是for循环代码:
FOR cur as select fsetcode from lsetlist where fyear = p_year order by fsetcode
do
--插入临时表数据
set p_code=RTRIM(cast(char(cur.fsetcode) as varchar(10)));
CALL sp_query_stocks_detail_CIRC(p_code,
Integer(pvar_i_date1),
Integer(pvar_i_date2),
P_ERRORCODE,
P_ERRORMSG);
if P_ERRORCODE <> 0 then
rollback;
else
commit;
end if;
end for;
报以下错误:
数据库管理器发生错误。SQLCODE: -501, SQLSTATE: 24501 - The cursor specified in a FETCH or CLOSE statement is not open.. SQLCODE=-501, SQLSTATE=24501, DRIVER=4.11.69
请高手指点一下,谢谢!