SDO_UTIL Fails To Compile With PLS-753 Making Spatial Invalid
(Doc ID 2847160.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Spatial and Graph - Version 19.8.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Spatial component INVALID due to MDSYS.SDO_UTIL being invalid.
----
Attempt to manually validate the object:
SQL> alter PACKAGE MDSYS.SDO_UTIL compile body;
Warning: Package Body altered with compilation errors.
SQL> SHOW ERRORS;
Errors for PACKAGE BODY MDSYS.SDO_UTIL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00753: malformed or corrupted wrapped unit
----
Attempting to recreate SDO_UTIL by first running ?/md/admin/sdoutlh.sql is met with a lot of errors like:
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_SOURCE1) violated
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |