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 JUNE 30, 2023

Applies to:

Oracle Spatial and Graph - Version and later
Oracle Text - Version to [Release 12.1]
Information in this document applies to any platform.


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.