My Oracle Support Banner

How To Force Oracle Database NLS_LENGTH_SEMANTICS Within ODI (Doc ID 1303649.1)

Last updated on MARCH 13, 2025

Applies to:

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

Goal

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:

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.

The article applies to the current 12C release.

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.