My Oracle Support Banner

Why DBMS_AQ_MONITOR_UTIL Invalid after upgrading the database from 12.1.0.2 to 19.6 (Doc ID 2685804.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.6.0.0.0 and later
Information in this document applies to any platform.

Goal

Following upgrading the database from 12.1.0.2 to 19.6, AQMON_.DBMS_AQ_MONITOR_UTIL is invalid.

SQL> select * from dba_errors where name = 'DBMS_AQ_MONITOR_UTIL';

OWNER
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SEQUENCE LINE POSITION
------------------- ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
AQMON
DBMS_AQ_MONITOR_UTIL
PACKAGE BODY 1 8543 7
PLS-00306: wrong number or types of arguments in call to 'PURGE_QUEUE_TABLE'
ERROR 306
 

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


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