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 10.2.0.3 to 10.2.0.3 [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.
10.2.0.1, 10.2.0.2, and 10.2.0.3 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