My Oracle Support Banner

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

Last updated on APRIL 01, 2020

Applies to:

Oracle Spatial and Graph - Version 10.2.0.1 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.