My Oracle Support Banner

Getting Ora-01722: Invalid Number When Upgrading Argus Safety From 4.2_sp1hf2 To 5.0 (Doc ID 1361623.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 5.0.0 and later
Information in this document applies to any platform.

Symptoms

Getting ORA-01722: invalid number when upgrading Argus Safety from 4.2_SP1HF2 to 5.0

Update cmn_profile set value ='CASE' WHERE KEY = 'NUMBERING_DATE' AND VALUE = 1;

SQL execution error, ORA-01722: invalid number

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
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.