Calling REF CURSOR Containing NULL Value Fails With ArrayIndexOutOfBoundsException (Doc ID 1969926.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version 10.1.0.2 to 12.1.0.2.0 [Release 10.1 to 12.1]
Information in this document applies to any platform.

Symptoms

When using the 10g, 11g, or 12c JDBC driver, returning a resultset from a ref cursor fails with the following error:

  java.lang.ArrayIndexOutOfBoundsException

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.

Specifically:
* 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

Cause

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