My Oracle Support Banner

Spatial Is Invalid And There Are Invalid MDSYS Package Bodies Where The Compilation Raises PLS-201 errors (Doc ID 1476866.1)

Last updated on JANUARY 23, 2019

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 and later
Oracle Text - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 21-Jan-2014***

Symptoms

Spatial component is invalid in DBA_REGISTRY.

DBA_OBJECTS view contains invalid MDSYS package bodies, example MDSYS.SDO_OLS, and
DBA_ERRORS view contains PLS-201 and PLS-320 errors for these invalid package bodies, example

PLS-00201: identifier 'UTL_HTTP' 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


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