原文: 游標(biāo)的使用

定義游標(biāo)：

        cursor calenderStatus_cur 

    is

    select * from ut_calenderStatus ;

    vr_calenderStatus      ut_calenderStatus % rowtype;
  

打開(kāi)游標(biāo)，提取游標(biāo)中的數(shù)據(jù)到游標(biāo)行中：

        open calenderStatus_cur;

        loop

          fetch calenderStatus_cur into vr_calenderStatus;

          exit when calenderStatus_cur % notfound;

          up_日歷_產(chǎn)品開(kāi)放期設(shè)置(pi_serviceid,pi_opid,vr_calenderStatus.Calenderstatus,vr_calenderStatus.Fundcode,'0',pi_rq,pi_begin,pi_end,

                                       vr_calenderStatus.m,vr_calenderStatus.n,vr_calenderStatus.Prolong,po_returnmsg ,po_returncode); 

          if po_returncode <> '0000' then

           rollback;

           return;

          end if;          

        end loop;

    close calenderStatus_cur;
  

游標(biāo)的使用