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
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'.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms