• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
I did the upgrade and applied the patch, but I got this error when I run the utlrp.sql
Right now everything is up and running.
Should I worry?
"OBJECTS WITH ERRORS
-------------------
1
1 row selected.
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
0
1 row selected.
PL/SQL procedure successfully completed.”

I did
idle> select obj#,owner#,name, namespace, type#,status from obj$ where status=3;
OBJ# OWNER# NAME NAMESPACE TYPE# STATUS
---------- ---------- -------------------- ---------- ---------- ----------
46115 46 SDO_3GL 2 11 3
1 row selected.

Does it mean that the package name is SDO_3GL and I have to run the sql?

Sql>alter package schemaname.packagename compile;

[Later:]

this is what I tried and the messages that I got.
1.
idle> select owner, object_type, object_name from dba_objects where status <> 'VALID';
OWNER OBJECT_TYPE OBJECT_NAME
------------------------------ ------------------- ------------------------------
MDSYS PACKAGE BODY SDO_3GL

2.
idle> alter package MDSYS.SDO_3GL compile;
Warning: Package altered with compilation errors.
3.

idle> alter package MDSYS.SDO_3GL compile body;
Warning: Package Body altered with compilation errors.



[Later:]

aleph_admin@ALEPH18> aleph_admin@ALEPH18> connect mdsys/mdsys Connected.
aleph_admin@ALEPH18> select name,text from user_errors;
NAME TEXT
SDO_3GL PLS-00302: component 'CONVERT_DISTANCE' must be declared
SDO_3GL PLS-00302: component 'CONVERT_DISTANCE' must be declared
SDO_3GL PLS-00302: component 'EXPAND_MULTI_POINT' must be declared

Resolution:
Ex Libris response: Failure in compilation of MDSYS.SDO_3GL can be ignored as it is not used.

• Article last edited: 10/8/2013