Error "ORA-01858: a non-numeric character was found where a numeric was expected" Upgrading Portal Repository from 10.1.4.2 To 11.1.1.6

(Doc ID 2038362.1)

Last updated on OCTOBER 09, 2017

Applies to:

Portal - Version 10.1.4.0 to 11.1.1.7.0 [Release 10gR2 to FMW11g]
Information in this document applies to any platform.

Symptoms

During the upgrade from 10g to 11g, the upgrade is failing due to this error in the upgrade log:

ERROR: Creating the Oracle Portal Builder Page
declare
  *
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWSBR_API", line 1982
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at line 1661

 

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