AW: ORA-1002, Fetch out of sequence

I think this is not true, cause when I sent a commit the next fetch = works
fine.

Mit freundlichen Gr=FC=DFen

i. V. Volker Sch=F6n
INPLAN RUHR
Informationstechnik GmbH
Tel.: +49 208 / 65 91 - 950
Fax: +49 208 / 65 91 - 980
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: Scott Canaan [mailto:srcdco_at_ritvax.isc.rit.edu] Gesendet: 05. October 2000 15:56
An: Multiple recipients of list ORACLE-L Betreff: Re: ORA-1002, Fetch out of sequence

Schoen,

    You can't do another fetch from the cursor once a commit or = rollback has
been issued. Both commands will automatically close all open cursors. = That
is
why you are getting the ORA-01002: Fetch out of sequence. The cursor = is no
longer open, therefore there are no more rows to be returned.

Schoen Volker wrote:

> 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
> http://www.inplan.de
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Schoen Volker
> INET: v.schoen_at_inplan.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Scott Canaan (srcdco_at_rit.edu)
"Life is like a sewer, what you get out of it depends on what you put =
into
it" -
Tom Lehrer


--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Scott Canaan
  INET: srcdco_at_ritvax.isc.rit.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may