My Oracle Support Banner

OLAPSYS.CWM2_OLAP_OLAPAPI_ENABLE Package Body Is Invalid (Doc ID 731574.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Oracle OLAP - Version 10.2.0.3 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

The Olapsys.CWM2_OLAP_OLAPAPI_ENABLE package body is invalid and you receive an error when you try to compile it.

SQL> select owner,status,object_type from dba_objects where object_name =
'CWM2_OLAP_OLAPAPI_ENABLE'
2 ;

OWNER STATUS OBJECT_TYPE
------------------------------ ------- -------------------
PUBLIC VALID SYNONYM
OLAPSYS VALID PACKAGE
OLAPSYS INVALID PACKAGE BODY

SQL> alter package olapsys.CWM2_OLAP_OLAPAPI_ENABLE compile body;

Warning: Package Body altered with compilation errors.

Changes

 

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

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