My Oracle Support Banner

After upgrade, running SDO_UTIL package fails with ORA-04063: package body "MDSYS.SDO_UTIL" (Doc ID 1439542.1)

Last updated on MARCH 20, 2013

Applies to:

Oracle Spatial - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

After upgrade, getting the following error when trying to use the SDO_UTIL package:


SELECT t.x
, t.y
FROM ugdbowner.gc_layer_events e
, TABLE(SDO_UTIL.GETVERTICES(e.geom)) t
WHERE rownum < 11; 2 3 4 5
FROM ugdbowner.gc_layer_events e
*
ERROR at line 3:
ORA-04063: package body "MDSYS.SDO_UTIL" has errors



Spatial component is invalid:

select comp_id, control, schema, version, status, comp_name from dba_registry where comp_id='SDO';

COMP_ID CONTROL SCHEMA VERSION STATUS COMP_NAME
---------- ---------- ---------- ------------ ---------- --------------------
SDO SYS MDSYS 11.2.0.3.0 INVALID Spatial


SDO_UTIL is invalid:

select object_name, object_type, status from dba_objects
  where owner='MDSYS' and status <> 'VALID'
  order by object_name;

OBJECT_NAME OBJECT_TYPE STATUS
----------------------------------- -------------------- ----------
SDO_UTIL PACKAGE BODY INVALID


SDO_UTIL fails to compile with the following error:

PLS-00306: wrong number or types of arguments in call to 'VERTEX_TYPE'

Changes

Upgraded database from 10.2.0.4 to 11.2.0.3

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.