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 9.2.0.6 to 10.1.0.3 [Release 9.2 to 10.1]
Information in this document applies to any platform.

Symptoms

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 10.1.0.2.0 or 10.1.0.3.0 JDBC thin driver to connect to the database.

Changes

Upgrading JDBC Driver and Database.

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