My Oracle Support Banner

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 to [Release 10.2]
Information in this document applies to any platform.


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.  



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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