My Oracle Support Banner

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.

Purpose


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.

Scope

This article is intended for all users of Advanced Queuing (AQ).

 

Details

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
Purpose
Scope
Details
 RELATED DOCUMENTS

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