ORA-1002, Fetch out of sequence

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Thu, 5 Oct 2000 13:19:34 +0200
Message-Id: <10640.118568@fatcity.com>

Hi list,

I've a problem with a procedure. In the procedure I open a cursor and = make
fetches from a table in a loop. When I get a error I make a rollback in = this
loop and want to fetch the next row. After the rollback I get ora-1002: Fetch out of sequence. I don't use SELECT FOR UPDATE.

here the part with the rollback:

 begin

    if rtrim(telUmschlaganweisung.Gesamtmenge) is not null then

       r.GESAMTMENGE :=3D =
to_number(telUmschlaganweisung.GesamtMenge);

	 else
	    r.GESAMTMENGE     :=3DNULL;
	 end if;

 exception
   when others then

  	     strMsg :=3D 'Gesamtmenge nicht numerisch!';
		  	Rollback;
		   if Fehler_protokollieren( strMsg ,tVerw, u) =3D false then
		      RETURN FALSE;
			end if ;
			bFehlerAufgetreten :=3D true;
			Commit;

 end;

If everything is OK and the procedure makes a COMMIT teh procedure = produces
no errors.

Here my environment:
Oracle 7.3.4.5.0 Windows NT 4.0 SP5

TIA Regards

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de Received on Thu Oct 05 2000 - 06:19:34 CDT