RE: fetch out of sequence

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 23 Aug 2004 09:20:11 -0400
Message-ID: <543DF856D23431489D4B8028C300FBAB08AC93C2@exchsen0a1mb>

Paula,

Check the proc. According to the docmentation:

Cause: In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set after all records have been fetched. This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may also cause this error.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Paula_Stankus_at_doh.state.fl.us [mailto:Paula_Stankus_at_doh.state.fl.us] Sent: Monday, August 23, 2004 9:13 AM
To: oracle-l_at_freelists.org
Subject: RE: fetch out of sequence

Guys,

I have a database and packages/procs, I have recently inherited with = little info. It runs successfully in another 9.2.0.4 database I setup = on another host. Same database setup, version, processes and = procedures. However, I am getting a specific error message:

ORA-01002: fetch out of sequence

My thinking is that it likely is an issue with how the proc. is coded. = However, I also think the reason it hasn't come up on the other database = environment is that the number of rows would have been around 100K = versus 800K (due to a delay in running this nightly batch process).

Any suggestions on what to look for in the code with the specific error = above could the number of rows make the difference?

Thanks,
Paula

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Aug 23 2004 - 08:17:17 CDT