Invalid object BIS_TRUNCATE_EMPTY_MV_LOG_PKG on 11.5.10 (Doc ID 392303.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Application Install - Version: 11.5.10 to 11.5.10.2
This problem can occur on any platform.
Application Install - Version: 11.5.10 to 11.5.10.2

Symptoms

Invalid package BIS_TRUNCATE_EMPTY_MV_LOG_PKG with error:

SQL> alter PACKAGE BIS_TRUNCATE_EMPTY_MV_LOG_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY BIS_TRUNCATE_EMPTY_MV_LOG_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
38/10 PLS-00341: declaration of cursor 'MV_REFRESH' is incomplete or malformed
39/5 PL/SQL: SQL Statement ignored
40/10 PL/SQL: ORA-00942: table or view does not exist
42/18 PL/SQL: Item ignored
82/5 PL/SQL: SQL Statement ignored
82/27 PLS-00320: the declaration of the type of this expression is incomplete or malformed
85/5 PL/SQL: Statement ignored
85/48 PLS-00320: the declaration of the type of this expression is incomplete or malformed


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