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 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Oracle Database Gateway for Informix - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Generic Windows
***Checked for relevance on 22-Nov-2010***


Symptoms

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.

Cause

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
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.