Invalid package body MDPRVT_IDX error ORA-00947: Not Enough Values (Doc ID 1520532.1)

Last updated on OCTOBER 07, 2013

Applies to:

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

Symptoms

Invalid package body MDPRVT_IDX after upgrading to 11.2.0.2 or 11.2.0.3.
  ...
  CREATE OR REPLACE PACKAGE BODY mdprvt_idx wrapped
  ...
  107 /

  Warning: Package Body created with compilation errors.

  show errors;
  Errors for PACKAGE BODY MDPRVT_IDX:

  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  706/7 PL/SQL: SQL Statement ignored
  706/25 PL/SQL: ORA-00947: not enough values
  ...

leaving the STATUS of Spatial as INVALID:

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