Semantic Technologies Errors During Upgrade From 11.2 To 12.1.0.2 (Doc ID 1920558.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Upgrading from 11.2.0.3 to 12.1.0.2

Error in Upgrade log:

10:21:58 SQL> -- Need to backup and truncate existing RDFCTX Indexes before we can update RDF_LINK$ for Named Graph --
10:21:58 SQL> prompt backing up existing SemContext indexes ...
backing up existing SemContext indexes ...
10:21:58 SQL>
10:21:58 SQL> declare
10:21:58 2 rdfctx_exists number;
10:21:58 3 rdfctx_ids SYS.ODCINumberList;
...
...
10:21:58 187 end if;
10:21:58 188 end;
10:21:58 189 /
ADD PARTITION MODEL_' || sdo_util.number_to_char(rdfctx_ids(i),'TM9') || '
  *
ERROR at line 91:
ORA-06550: line 91, column 50:
PLS-00302: component 'NUMBER_TO_CHAR' must be declared
ORA-06550: line 89, column 13:
PL/SQL: Statement ignored
ORA-06550: line 167, column 56:
PLS-00302: component 'NUMBER_TO_CHAR' must be declared
ORA-06550: line 165, column 15:
PL/SQL: Statement ignored
...
...
10:29:22 SQL> select line, text from dba_errors where owner='MDSYS';

  LINE
----------
TEXT
--------------------------------------------------------------------------------
  1158
PL/SQL: Statement ignored

  1159
PLS-00302: component 'NUMBER_TO_CHAR' must be declared

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