oracle 带入参的游标

 之前一直都看不懂游标里面带参数，今天仔细看了下终于看懂了，原来参数是当做入参来用的，现copy部分代码

PROCEDURE DEAL_PARTY_MOD_EVENTS_ROW(IN_AREAID   IN VARCHAR,
                                        IN_ROWSTATE IN VARCHAR,
                                        IN_end      IN VARCHAR) IS

cursor cur(i_areaId VARCHAR, i_rowstate VARCHAR) is
            select EVENT_ID,
                   AREA_ID,
                   TABLE_TYPE_CD,
                   MOD_OBJ_ID_1,
                   MOD_OBJ_TYPE_1,
                   MOD_OBJ_ID_2,
                   MOD_OBJ_TYPE_2,
                   DML_TYPE,
                   CREATE_DT,
                   CHANGE_VECTOR
              from PARTY_MOD_EVENTS p
             where p.AREA_ID = to_number(i_areaId)
               and p.STATE = i_rowstate
               AND p.mod_OBJ_ID_1 LIKE '%' || in_end || ''
             order by p.EVENT_ID;
        v_areaId varchar2(10);
    BEGIN
        if IN_AREAID is null then
            select area_id
              into v_areaId
              from SCRIPT_LOCAL_CONFIG
             where rownum = 1;
        else
            v_areaId := IN_AREAID;
        end if;
        open cur(v_areaId, IN_ROWSTATE);

  loop

 fetch cur bulk collect into v_EVENT_ID,xxx,limit 100;

            If (Cur%Notfound) Then
                Exit;
            End If;

   end loop;