ArrayIndexOutofBoundsException Fetching From Remote Tables With Kprb Driver (Doc ID 405269.1)

Last updated on AUGUST 09, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.3 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
10.2.0.1, 10.2.0.2, and 10.2.0.3 RDBMS Server

Symptoms

Executing a Java Stored Procedure that fetches multiple rows from a remote table fails with:

   java.lang.ArrayIndexOutOfBoundsException

after an upgrade to 10.2.


The same query executed in sqlplus across the dblink works fine.

The same java stored procedure works when querying local tables.

This java stored procedure code works when executed in eralier versions.

Setting both Statement and ResultSet fetch size to 1 works. (stmt.setfetchsize(1) and rset.setfetchsize(1))

Using the JDBC Thin driver instead works.

The java stored procedure ALWAYS RETURN THE LAST RECORD back first, even if the query statment has an "Order by" clause.

Depending on the ResultSet.getXXX() method used, the procedure may throw  'SQLException: numeric overflow'.

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