| Reg. ORA-01002 Fetch Out Of Sequence [message #88992] |
Mon, 21 July 2003 10:00  |
P.V.Rao
Messages: 6
Registered: May 2003
|
Junior Member |
|
|
I am getting ORA-01002 (Fetch out of sequence) Error from both Front and Backends. I am Using Oracle 8i database and Forms 4.5, Reports 2.5. For simple select statements also giving the above error (some times only). Sometimes the same query is giving output.
Pls. give me a solution to overcome above problem.
|
|
|
|
| Re: Reg. ORA-01002 Fetch Out Of Sequence [message #88996 is a reply to message #88992] |
Wed, 23 July 2003 06:30  |
Rahman
Messages: 40
Registered: July 2003
|
Member |
|
|
hi Mr.Rao,
Read the following:-
ORA-01002 (Fetch out of sequence) Error :-
Reason: 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.
Action: Parse and execute a SQL statement before attempting to fetch the data.
do it
bye
Rahman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
