Receiving Errors for PACKAGE MDSYS.SDO_GCDR When Running MWM_Geocoder_install.sql on MWM v2.0.1 (Doc ID 1224024.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle Utilities Mobile Workforce Management - Version: 2.0.1 and later   [Release: 2.0 and later ]
Oracle Utilities Framework - Version: 4.0.0 and later    [Release: 4.0 and later]
Information in this document applies to any platform.

Symptoms

When running MWM_Geocoder_install.sql as stated in page 18 of Oracle Utilities Mobile Workforce Management (MWM) Database Administrator’s Guide Release 2.0.1 E17823-02, the following errors are encountered.  The database is Oracle Enterprise Edition without Spatial Option enabled.

Warning: Package created with compilation errors.

Errors for PACKAGE MDSYS.SDO_GCDR:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/3 PL/SQL: Declaration ignored
3/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared
6/3 PL/SQL: Declaration ignored
10/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared
13/3 PL/SQL: Declaration ignored
17/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared
20/3 PL/SQL: Declaration ignored
23/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared
26/3 PL/SQL: Declaration ignored
28/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared
31/3 PL/SQL: Declaration ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
33/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared
36/3 PL/SQL: Declaration ignored
38/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared
41/3 PL/SQL: Declaration ignored
43/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared
46/3 PL/SQL: Declaration ignored
48/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared
51/3 PL/SQL: Declaration ignored
53/10 PLS-00201: identifier 'SDO_KEYWORDARRAY' must be declared

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY MDSYS.SDO_GCDR:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00304: cannot compile body of 'SDO_GCDR' without its specification
1/14 PLS-00905: object MDSYS.SDO_GCDR is invalid

Grant succeeded.

Synonym created.

grant execute on mdsys.sdo_keywordarray to public with grant option
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist

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