My Oracle Support Banner

ORA-910 Selecting Informix Character Columns Greater Than Length 667 Using 11g Database Gateway And An Oracle Unicode Database (Doc ID 734164.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1]
Oracle Database Gateway for Informix - Version to [Release 11.1]
Generic Windows


Using Database Gateway for Informix (DG4IFMX)  or Database Gateway for ODBC (DG4ODBC) on Windows gives the erorr -

ORA-910 - specified length too long for its datatype

for the following circumstances -
- column defined as CHAR or VARCHAR longer than 666 character - eg varchar(1000) on Informix
- data in a row is 667 or greater characters
- the Oracle database is a Unicode database

Rows that are 666 or less in length can be selected successfully.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.