How To Resolve ORA-24035 On DBMS_AQADM.REMOVE_SUBSCRIBER
(Doc ID 104332.1)
Last updated on JANUARY 24, 2020
Applies to:Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
This article will discuss and demonstrate how to resolve an ORA-24035 error received when attempting to remove a subscriber from a queue using DBMS_AQADM.REMOVE_SUBSCRIBER.
The error indicates there is no such subscriber specified in the DBMS_AQADM.REMOVE_SUBSCRIBER procedure.
This article will guide users through a process that shows the databases views to be checked to confirm the error, and it includes the necessary SQL and PL/SQL to set up an Advanced Queuing test case.
This article is intended for all users of Advanced Queuing (AQ).
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