OWB Mapping Execution Fails With ORA-06502 - character string buffer too small (Doc ID 1304780.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.

Symptoms

A mapping uses its mapping name through the get_model_name expression.
The mapping name is between 28 to 30 character long.

The mapping execution was successful in OWB 10.1.
In OWB 10.2, it fails to execute with:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Changes

Upgrade to OWB 10.2 or higher.

Cause

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