My Oracle Support Banner

ORA-1002 'fetch out of sequence' When Using 'select... for update' in JDBC (Doc ID 1016747.102)

Last updated on FEBRUARY 06, 2024

Applies to:

JDBC - Version 9.0.1.0 and later
Information in this document applies to any platform.

Symptoms

When executing a 'select ... for update' clause through JDBC, you receive the following error:

java.sql.SQLException: ORA-1002: fetch out of sequence
void oracle.jdbc.ttc7.TTIoer.processError()
void oracle.jdbc.ttc7.Oall7.receive()
oracle.jdbc.ttc7.Oall7 oracle.jdbc.ttc7.TTC7Protocol.doOall7(long, int, byte[],
oracle.jdbc.dbaccess.DBType[], oracle.jdbc.dbaccess.DBData[], int,
oracle.jdbc.dbaccess.DBType[], oracle.jdbc.dbaccess.DBData[], int)
int oracle.jdbc.ttc7.TTC7Protocol.fetch(oracle.jdbc.dbaccess.DBStatement,
oracle.jdbc.dbaccess.DBType[], oracle.jdbc.dbaccess.DBData[], int)
void oracle.jdbc.driver.OracleStatement.doExecuteQuery()
void oracle.jdbc.driver.OracleStatement.doExecute()
void oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(java.lang.String)
java.sql.ResultSet oracle.jdbc.driver.OracleStatement.executeQuery(java.lang.String)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.