oracle 游标使用 带参数

CURSOR myCursor(DISPACHNO DB_WFS_RPTWFSLIST1.Dispachno%type) is select t.starttime,t.depachdatefrom RPTDATA.DB_WFS_RPTWFSLIST1 twhere t.achivedate between to_date(iStartTime' 00:00:00','YYYY-MM-DD HH24:MI:SS') and to_date(iEndTime' 23:59:59', 'YYYY-MM-DD HH24:MI:SS')and t.dispachno = DISPACHNO;


loop fetch myCursor2 into DISPACHNO; exit when myCursor2%notfound; if myCursor%isopen = false then open myCursor(DISPACHNO); end if;
end loop;close myCursor;