My Oracle Support Banner

"ORA-06502: PL/SQL: numeric or value error: character string buffer too small" Running Domainman During Migration or Domain Copy (Doc ID 2933201.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Transportation Management - Version 6.4.3 and later
Information in this document applies to any platform.

Symptoms

The following error may be generated trying to run domain copy.

EXEC pkg_novpd_domain_copy.generate_load_script;
BEGIN pkg_novpd_domain_copy.generate_load_script; END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "GLOGOWNER.DOMAINMAN", line 179
ORA-06512: at "GLOGOWNER.DOMAINMAN", line 232
ORA-06512: at "GLOGOWNER.DOMAINMAN", line 571
ORA-06512: at "GLOGOWNER.DOMAINMAN", line 1062
ORA-06512: at "GLOGOWNER.PKG_NOVPD_DOMAIN_COPY", line 485
ORA-06512: at "GLOGOWNER.PKG_NOVPD_DOMAIN_COPY", line 2194
ORA-06512: at "GLOGOWNER.PKG_NOVPD_DOMAIN_COPY", line 2225
ORA-06512: at line 1

Similar errors could also be generated when migrating from 6.4.3 to 6.5.1, or 6.5.1 to 6.5.2.

Loading table sequence...
BEGIN domainman.load_table_sequence; END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "GLOGOWNER.DOMAINMAN", line 172
ORA-06512: at "GLOGOWNER.DOMAINMAN", line 225
ORA-06512: at "GLOGOWNER.DOMAINMAN", line 533
ORA-06512: at "GLOGOWNER.DOMAINMAN", line 1988
ORA-06512: at line 1

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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