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 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 25-Mar-2013***

Symptoms

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.




Changes

10046 trace files shows the following



select name,intcol#,segcol#,type#,length,nvl(precision#,0)
,decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),
178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),
null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property,
nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0)
from col$ where obj#=:1 order by intcol#

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