oracle游标

declare cursor v_cur is select o.file_id from 表1 o
left join 表2 f
on o.customer_id = f.factoryid
left join t_pdm_dic_filetype x
on o.file_type=x.file_type
where o.create_date >trunc(sysdate)-3 and o.temp_flag=‘1’ and o.process_result=‘0’;
v_fileId t_rule_schedule_task.file_id%TYPE;
begin
open v_cur;
LOOP
FETCH v_cur
INTO v_fileid;
EXIT WHEN v_cur%NOTFOUND;
pkg_general_dataprocess.sp_data_processex(v_fileid);
end loop;
close v_cur;

end;