fetch out of sequence 2004-08-23 - By Mercadante, Thomas F
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@(protected) [mailto:Paula_Stankus@(protected)]
Sent: Monday, August 23, 2004 9:13 AM
To: oracle-l@(protected)
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 (See ORA-01002.ora-code.com): 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@(protected) 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
