Package Body MDSYS.SDO_ROUTER_PARTITION is Invalid and Will Not Compile (Doc ID 1320893.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Unable to compile the Package body MDSYS.SDO_ROUTER_PARTITION. Manual compilation fails with following error -

SQL> alter package MDSYS.SDO_ROUTER_PARTITION compile BODY ;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY MDSYS.SDO_ROUTER_PARTITION:

LINE/COL ERROR
-------- -----------------------------------------------------------------
6/19 PL/SQL: Item ignored
6/19 PLS-00201: identifier 'UTL_FILE' must be declared
15/3 PL/SQL: Statement ignored
15/9 PLS-00201: identifier 'UTL_FILE' must be declared
19/5 PL/SQL: Statement ignored
19/24 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
..
913/3 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

SQL>

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