Re: Maximum fetch in a cursor

From: <sxbktm_at_my-deja.com>
Date: Tue, 28 Sep 1999 16:47:58 GMT
Message-ID: <7sqrfq$e3a$1@nnrp1.deja.com>

In article <7soghq$2r0$1_at_newsmaster.pathcom.com>,   "John Chiu" <johnc_at_relsol.com> wrote:
> Please post your code. It will help us to analyse your problem.
>
> John Chiu
>
>

set serveroutput on;
DECLARE

  v_imin number :=0;
  v_isec number :=0;
  v_cookie varchar2(50);

  --v_last_isec number := 0;
  v_new number :=0;
  v_last_cookie varchar2(50) := 'some junkinitialvalue';   max_count number;

  v_isession number :=1;
  v_row varchar2(50) :='junk';
  v_ihr number :=0;
v_web_date varchar2(13) :='12-12-99';

v_new_web_date varchar2(13) :='11-22-99'; v_diffdate number := 0;

  CURSOR c1 IS

      SELECT web_date,ihr,imin,isec,cookie,ROWID FROM weblogpl order by cookie,to_date(web_date);

      BEGIN
      OPEN c1;

  LOOP FETCH c1 INTO
v_web_date,v_ihr,v_imin,v_isec,v_cookie,v_row;   if c1%notfound then
   exit;
  end if;

  if ( v_cookie = v_last_cookie) then
    {do something }
  else

     {do something }
  end if;

      update weblogpl set isession = v_isession where v_row=rowid;   END LOOP;
  commit;
  close c1;
 END;
/

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 28 1999 - 11:47:58 CDT