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 22.214.171.124 to 126.96.36.199 [Release 11.1]
Oracle Database Gateway for Informix - Version 188.8.131.52 to 184.108.40.206 [Release 11.1]
***Checked for relevance on 22-Nov-2010***
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
|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.|