<java.sql.SQLException: ORA-01002: fetch out of sequence
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178

    <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
    Location
    Mesa, Arizona
    Posts
    1,204
    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