RE: fetch out of sequence
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Aug 2004 09:20:11 -0400
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@xxxxxxxxxxxxxxx [mailto:Paula_Stankus@xxxxxxxxxxxxxxx]
Sent: Monday, August 23, 2004 9:13 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
