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

Last updated on SEPTEMBER 23, 2011

Applies to:

Oracle Argus Safety - Version: 5.0 and later   [Release: 5.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

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