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

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 and later
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

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