Invalid Sdo_geom Package When Public Synonym COL is Dropped

(Doc ID 730545.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version to [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 25-Mar-2013***


MDSYS.SDO_GEOM package body is INVALID


SQL>alter package mdsys.sdo_geom compile body.
Warning. Package body altered with compilation errors

sho errors

Errors for package body mdsys.sdo_geom:

line/col error
3756/3 PL/SQL Sql statement ignored
3757/8 PL/SQL ORA-00942 Table or View does not exists.


10046 trace files shows the following

select name,intcol#,segcol#,type#,length,nvl(precision#,0)
from col$ where obj#=:1 order by intcol#


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