MDSYS.SDO_JAVA_STP & SAMCLUST_IMP_T Invalid

Jan 28, 2021 8:10AM

Hi Community, I am facing a situation where Spatial is INVALID.

COMP_NAME VERSION STATUS

-------------------------------------------------- ------------------------------ --------------------------------------------

Spatial 19.0.0.0.0 INVALID

SQL> alter package MDSYS.SDO_JAVA_STP compile body;

Warning: Package Body altered with compilation errors.

SQL> sho user

USER is "SYS"

SQL> sho err

Errors for PACKAGE BODY MDSYS.SDO_JAVA_STP:

LINE/COL ERROR

-------- -----------------------------------------------------------------

3/2 PL/SQL: Item ignored

3/2 PLS-00305: previous use of 'TO_GMLGEOMETRY' (at line 6) conflicts with this use

9/2 PL/SQL: Item ignored

9/2 PLS-00305: previous use of 'TO_GMLGEOMETRY' (at line 10) conflicts with this use

16/2 PL/SQL: Item ignored

16/2 PLS-00305: previous use of 'TO_GMLGEOMETRY' (at line 15) conflicts with this use

Spatial (MOSC)