My Oracle Support Banner

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

Last updated on MARCH 04, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.,, and RDBMS Server


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


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'.


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.