Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-01002:fetch out of sequence

 
raju parepally parepally
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear colleages,
i am getting this exception randomly when i am calling procedure from jsp page java.sql.SQLException RA-01002:fetch out of sequence this error is coming randomly when this error has occured i am not getting data from database i am willing to know the problem is it from jsp or database procedure

Thanx in advance
nagaraju
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do not post same question again.


following is the description of ORA-01002 error


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.



Shailesh
[ May 11, 2006: Message edited by: Shailesh Chandra ]
 
raju parepally parepally
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for your reply

regards
nagaraju
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic