DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002

    <java.sql.SQLException: ORA-01002: fetch out of sequence

    We are getting on a test database. Does someone know what this is and how to fix this?

  2. #2
    Join Date
    Mar 2002
    Mesa, Arizona
    Note:121551.1 says

    Problem Description -------------------
    Java.sql.sqlexception: ora-01002: Fetch out of sequence. This problem occurs running a select statement using a java aplication. This java aplication use jdbc drivers for Oracle 8i against a 7.3.x Database. The same select statement runs fine on SQLPLUS.

    Solution Description --------------------
    Change the jdbc driver from the jdbc 8i driver to the jdbc 7.3.x driver.

    Explanation -----------
    The problem occurs because of some incompatibility against the database and the JDBC Driver. After, use the right jdbc driver for 7.3.x the problem is solved.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.