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

Oracle Community | 330173 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    select emp_name, rowid from employee FOR UPDATE is not working using thin or OCI driv

    Oracle Community | 1 decade ago | 330173
    java.sql.SQLException: ORA-01002: fetch out of sequence
  2. 0

    select emp_name, rowid from employee FOR UPDATE is not working using thin or OCI driv

    Oracle Community | 1 decade ago | 330173
    java.sql.SQLException: ORA-01002: fetch out of sequence
  3. 0

    select emp_name, rowid from employee FOR UPDATE is not working using thin or OCI driv

    Oracle Community | 1 decade ago | 330173
    java.sql.SQLException: ORA-01002: fetch out of sequence
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-01002: fetch out of sequence on getObject with Oracle, under load

    Oracle Community | 1 decade ago | 666705
    java.sql.SQLException: ORA-01002: fetch out of sequence
  6. 0

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

    Stack Overflow | 5 years ago | chetan
    java.sql.SQLException: ORA-01002: fetch out of sequence

  1. rp 1 times, last 3 months ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-01002: fetch out of sequence

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
    1 frame
  3. oracle.jdbc.oci8
    OCIDBAccess.fetch
    1. oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1503)
    2. oracle.jdbc.oci8.OCIDBAccess.fetch(OCIDBAccess.java:1317)
    2 frames
  4. Oracle jdbc
    OracleStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1608)
    2. oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)
    3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805)
    4. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:410)
    4 frames
  5. Unknown
    DateTest.main
    1. DateTest.getData(DateTest.java:27)
    2. DateTest.<init>(DateTest.java:11)
    3. DateTest.main(DateTest.java:55)
    3 frames