My Oracle Support Banner

ARARCALL.sql ends with Archive Error Ora-06502 Ora-06512 character to number conversion error (Doc ID 373360.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Receivables - Version 11.5.8 to 11.5.10.3 [Release 11.5.8 to 11.5.10]
Information in this document applies to any platform.
EXECUTABLE:ARPURGE - New Archive and Purge
EXECUTABLE:ARARCALL - Call New Archive and Purge

Symptoms

On 11.5.8 in Production:
When attempting to run ARARCALL - Call New Archive and Purge program the following error occurs.

ERROR:
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 11

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


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