Spatial Is Invalid And There Are Invalid MDSYS Package Bodies Where The Compilation Raises PLS-201 errors

(Doc ID 1476866.1)

Last updated on OCTOBER 27, 2017

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


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms