My Oracle Support Banner

How To Validate Invalid Dbms_xsoq Package (Doc ID 807321.1)

Last updated on MARCH 15, 2012

Applies to:

Oracle OLAP - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Goal


DBMS_XSOQ package body is INVALID


You have checked and there is only one DBMS_XSOQ package and it is in the SYS schema.

When you try to recompile the package body, you receive errors:

SQL> alter package sys.DBMS_XSOQ compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY SYS.DBMS_XSOQ:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00753: malformed or corrupted wrapped unit

Solution

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
  Goal
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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