Oracle 嵌套游标、带参数的游标

CREATE OR REPLACE PROCEDURE update_Last_Deal_Department

AS

   v_mianinfoId zf_wf_transinfo.main_id%type;

   v_orgId zf_wf_transinfo.unit_id%type;

   v_i integer :=0;

   v_j integer :=0;

   v_k integer :=0;

   CURSOR c_mian_info_all IS

        SELECT zwm.id FROM  zf_wf_maininfo zwm  ;

   CURSOR c_queryTransByMainId(mian_id VARCHAR2) IS

        SELECT zft.unit_id FROM zf_wf_transinfo zft

               WHERE zft.main_id=mian_id ORDER BY zft.tran_date DESC ;