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 15, 2020

Applies to:

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


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


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

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