Can network problems cause an ORA-01002 fetch out of sequence error?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Can network problems cause an ORA-01002 fetch out of sequence error?

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    Can network problems cause an ORA-01002 fetch out of sequence error?

    A sql statement intermittently keeps getting an ORA-1002 fetch out of sequence error. I have informed the developers the possible causes, but he insists its a network problem that is causing this as elsewhere this works fine. Could this error be caused by a faulty network?

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443

    The error resides between the chair and the keyboard

    Definitely not, it's a programming error:
    ORA-01002 fetch out of sequence

    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.

    Action: Parse and execute a SQL statement before attempting to fetch the data.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    Thanks for your reply. I knew this but needed confirmation for the developer.
    Rgds. Sheryl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width