My Oracle Support Banner

SDO_3GL PACKAGE BODY INVALID AFTER APPLYING 10.2.0.4 (Doc ID 564939.1)

Last updated on JUNE 21, 2022

Applies to:

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

Symptoms

The package body MDSYS.SDO_3GL is invalid after database upgrade to 10.2.0.4

Errors for PACKAGE BODY SDO_3GL:


LINE/COL ERROR
-------- -----------------------------------------------------------------
1433/7 PL/SQL: Statement ignored
1433/28 PLS-00302: component 'CONVERT_DISTANCE' must be declared
1447/9 PL/SQL: Statement ignored
1447/26 PLS-00302: component 'CONVERT_DISTANCE' must be declared
1471/7 PL/SQL: Statement ignored
1471/24 PLS-00302: component 'EXPAND_MULTI_POINT' must be declared

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.