存储过程-动态游标

TYPE detail_cur_ref IS REF CURSOR;  --定义一个动态游标
detail_cur_v detail_cur_ref;
--查询数据id
 sql_v:='select sa.sa_id from ZD_PRODUCE_PLAN_SHIFT_ARTEFACT sa where sa.plan_shift_id='''||planShiftId||''' and sa.detail_id='''||v_d.unqualified_small_id||'''';
     begin
     OPEN detail_cur_v for sql_v;
        LOOP
           FETCH detail_cur_v INTO artefact_id;
           --游标取不到数据则退出
           EXIT WHEN detail_cur_v%NOTFOUND;
           artefact_id:=artefact_id;
        END LOOP;
     CLOSE detail_cur_v;
     end;