Using Oracle10g JDBC Thin With REF CURSOR Fails With SQLException: Bigger type length than Maximum

(Doc ID 304402.1)

Last updated on AUGUST 16, 2016

Applies to:

JDBC - Version to [Release 9.2 to 10.1]
Information in this document applies to any platform.


When using a callable statement to invoke a PL/SQL procedure that returns a ref cursor it will throw following exception:
java.sql.SQLException: Bigger type length than Maximum
This happens only when either using an Oracle10g JDBC or JDBC thin driver to connect to the database.


Upgrading JDBC Driver and Database.


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