Error ORA-1401 Occured With Oracle ODBC Driver When CURSOR_SHARING=FORCE or SIMILAR (Doc ID 392914.1)

Last updated on SEPTEMBER 24, 2010

Applies to:

Oracle ODBC Driver - Version: 9.2.0.8 and later   [Release: 9.2 and later ]
Microsoft Windows (32-bit)

Symptoms

After changing  initialization parameter from

 

CURSOR_SHARING=EXACT

 

 to

 

CURSOR_SHARING=FORCE

 

or

 

CURSOR_SHARING=SIMILAR

 

and bouncing database followed by access through application using ODBC Driver

 

ORA-1401: Inserted value too large for column

 

is raised

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