How To Force Oracle Database NLS_LENGTH_SEMANTICS Within ODI

(Doc ID 1303649.1)

Last updated on JANUARY 05, 2018

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


It may happens that NLS_LENGTH_SEMANTICS are not coherent between Data Sources and Targets.

As a result, the following alternative messages might be signaled at runtime of Oracle Data Integrator (ODI) Integration Interfaces:

ORA-01401: inserted value too large for column


ORA-01459: invalid length for variable character string


ORA-25137: Data value out of range


ORA-12899: value too large for column

or, if using ODBC:

8000 : S1090 : sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Oracle][ODBC]Invalid string or buffer length

If it is not desired to update NLS_LENGTH_SEMANTICS at the database level, and if ODI Integration Interfaces have already been developed... it is feasible to force it at ODI level.


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