My Oracle Support Banner

DPLOAD.SQL Fails With ORA-06512: At "SYS.KU$_DPLOAD" When NLS_NUMERIC_CHARACTERS=',.' (Doc ID 2503446.1)

Last updated on APRIL 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Reload of DataPump with dpload script or the execution of datapatch done as post-installation step for a DataPump patch fail with multiple ORA-06502 like:

SQL> SELECT ku$_dpload.for_version('catnodpaq.sql', '12.2.0.2') AS fname FROM dual;
SELECT ku$_dpload.for_version('catnodpaq.sql', '12.2.0.2') AS fname FROM dual
  *
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "SYS.KU$_DPLOAD", line 6
ORA-06512: at line 1
...

 

Changes

Upgrade to 18.1 or above

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.