My Oracle Support Banner

ODI Knowledge Module "IKM Oracle Partition Exchange Load" Fails with "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" (Doc ID 3036692.1)

Last updated on JULY 30, 2024

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 to 12.2.1.4.240405
Oracle Data Integrator - Version 12.2.1.4.0 to 12.2.1.4.240405 [Release 12c]
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) 12.2.1.4 mapping that uses the out-of-box "IKM Oracle Partition Exchange Load" Knowledge Module (KM), fails to execute with the following error:


 

The issue occurs if the table / column length are larger than 30 characters.

To reproduce:

  1. Create a mapping that uses the IKM Oracle Partition Exchange Load.
  2. Set Oracle Technology from default value (30) to Maximum Table Length and Column Length both to "128".
  3. Run the mapping.


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.