Calling REF CURSOR Containing NULL Value Fails With ArrayIndexOutOfBoundsException
Last updated on MARCH 08, 2017
Applies to:JDBC - Version 10.1.0.2 to 184.108.40.206.0 [Release 10.1 to 12.1]
Information in this document applies to any platform.
When using the 10g, 11g, or 12c JDBC driver, returning a resultset from a ref cursor fails with the following error:
This happens when one of the numeric columns within the ref cursor contains a null value.
This problem did not reproduce when using the 9.2 JDBC drivers.
* The 9.2.x.x JDBC drivers return the value with no errors.
* The 10.1.0.2 JDBC driver fails with the error "Bigger type length than Maximum"
* The 10.2.x.x, 11.1.x.x, 11.2.x.x, and 12.1.x.x JDBC drivers all fail with java.lang.ArrayIndexOutOfBoundsException
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