prepare stmt from 'declare cur_person_key cursor for
select person_key from manuscript_authors
where manu_id=''?''
order by author_order';
execute stmt using @manu_in_ready;
open cur_person_key;
提示Undefined CURSOR: cur_person_key;请问各位哪里出错了啊?
select person_key from manuscript_authors
where manu_id=''?''
order by author_order';
execute stmt using @manu_in_ready;
open cur_person_key;
提示Undefined CURSOR: cur_person_key;请问各位哪里出错了啊?
exec('declare cur_manu_in_ready cursor for
select ms.manu_number,mr.manuscript_id,mr.page_extent,pt.name,pt.name
from manuscript_ready mr left join plancolumn_type pt on mr.plan_column=pt.plancolumn_id
left join manuscript ms on mr.manuscript_id=ms.manu_id
where ms.manu_number in '+@GaoHaoList)
open cur_manu_in_ready
FETCH NEXT FROM cur_manu_in_ready INTO @GaoHao,@manu_in_ready,@page_extent,@tmpLanMu,@tmpLanMu_E
改成mysql的存储过程。