A CallableStatement that Returns a Cursor Throws Error "java.sql.SQLException: OALL8 is in an inconsistent state."

(Doc ID 317385.1)

Last updated on FEBRUARY 14, 2018

Applies to:

JDBC - Version to [Release 10.1]
Information in this document applies to any platform.
Checked for relevance on 14-Jan-2008
***Checked for relevance on 17-Apr-2012***


When the java program is executing a CallableStatement that returns a cursor, following error can occur:

java.sql.SQLException: OALL8 is in an inconsistent state.

This problem comes up only when:

It works when using classes12.zip with jdk 1.2/1.3


Upgrade of JDBC THIN Driver.
This might be an implicit upgrade by upgrading other software like application server.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms