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

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