ORA-6502 when executing an OWB 10.2 mapping
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.
When executing an OWB 10.2 mapping, it crashes with the following PL/SQL error:
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.
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