ORA-6502 when executing an OWB 10.2 mapping (Doc ID 741321.1)

Last updated on JULY 11, 2014

Applies to:

Oracle Warehouse Builder - Version 10.2.0.1 to 10.2.0.2 [Release 10.2]
Information in this document applies to any platform.

Symptoms

When executing an OWB 10.2 mapping, it crashes with the following PL/SQL error:

ORA-06502 :PL/SQL:numeric or value error: character string 
buffer too  small  
ORA-06512: at "user.procedure", line 9670  
ORA-06512: at "user.procedure", line 14788  
ORA-06512: at line 1 

The generate code shows a column taking more than the size assigned to it.
get_source_name is a column of size varchar2(2000). But at times it takes more than this size and fails with above error.

If the assigned value is less than 2000 characters, the mapping executes fine.  

get_source_name CONSTANT VARCHAR2(2000) := '"CLS1_STUDENT_COURSE_ATTEMPT","CLS1_COURSE_VERSION","CLS1_STUDENT_COURSE_ATTEMPT","CLS1_CANDIDATURE_ATT_HIST","CLS1_CANDIDATURE","CLS1_CL_COURSE_COMPLETION","CLS1_CANDIDATURE_EFTD","CLS1_STUDENT_COURSE_ATTEMPT","CLS1_COURSE_VERSION","CLS1_STUDENT_COURSE_ATTEMPT","CLS1_CANDIDATURE_ATT_HIST"...;

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