My Oracle Support Banner

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

Last updated on FEBRUARY 28, 2023

Applies to:

JDBC - Version to [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 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


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

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