求助DB2的大神:
create or replace procedure sp_fr_insert_data(
in i_dataowner varchar(10),
in i_comdate date
) begin
declare v_dataowner varchar(10);
declare v_comdate date;
set v_comdate = null;
set v_dataowner = null;
set v_comdate = to_date(‘2018-01-31’,‘yyyy-mm-dd’);
while v_comdate<to_date(‘2018-09-30’,‘yyyy-mm-dd’)
do
for c_cursor as cc cursor for
select distinct(dataowner)aa from tbl_department for read only
do
– open c_cursor
set v_dataowner = c_cursor.aa;
insert into whq_test (dataowner,comdate)values(v_dataowner,v_comdate);
call sp_prerec_fr_day_new(v_comdate,v_dataowner);
call sp_prerec_edor_fr_day_new(v_dataowner,v_comdate);
end for;
set v_comdate = add_months(v_comdate,1);
end while;
end;
在调用函数的时候报了: The cursor specified in a FETCH statement or CLOSE statement is not open or a cursor variable in a cursor scalar function reference is not open.FETCH语句或关闭语句中指定的光标不是在光标标量函数中打开或游标变量引用是不开放。。。这个错
是什么原因。求大神指点。
DB2:The cursor specified in a FETCH statement or CLOSE statement is not open or a cursor variable in
最新推荐文章于 2024-01-22 10:45:35 发布