My Oracle Support Banner

ODI Executing LKM BICC to ADW External Table Fails with "PLS-00172: String Literal Too Long" (Doc ID 2679865.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version 2.0.2 to 12.2.1.4.220426
Oracle Data Integrator - Version 12.2.1.3.0 to 12.2.1.4.220426 [Release 12c]
Information in this document applies to any platform.

Symptoms

When using Oracle Data Integrator (ODI) to load data from Business Intelligence Cloud Connector (BICC) to Autonomous Data Warehouse (ADW) using LKM BICC to ADW External Table the following error is thrown:

Changes

 

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!

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