A CallableStatement that Returns a Cursor Throws Error "java.sql.SQLException: OALL8 is in an inconsistent state."
Last updated on FEBRUARY 14, 2018
Applies to:JDBC - Version 10.1.0.2 to 10.1.0.4 [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:
- using JDBC THIN driver 10.1.0.2.0 and 10.1.0.3.0
- and using ojdbc14.jar (jdk 1.4)
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