Select Queue Subscribers

Figure 10-12 Use Case Diagram: Select Queue Subscribers

To refer to the table of all basic operations having to do with the Operational Interface see: "Use Case Model: Administrative Interface -- Views"

Name of View:

AQ$<queue_table_name>_S

Purpose:

This is a view of all the subscribers for all the queues in any given queue table. This view is generated when the queue table is created and is called aq$<queue_table_name>_s.This view is used to query subscribers for any or all the queues in this queue table. Note that this view is only created for 8.1-compatible queue tables.

Table 10-12 AQ$<queue_table_name>_S

Column Name & Description	Null?	Type
QUEUE - name of Queue for which subscriber is defined	NOT NULL	VARCHAR2(30)
NAME - name of Agent		VARCHAR2(30)
ADDRESS - address of Agent		VARCHAR2(1024)
PROTOCOL - protocol of Agent		NUMBER

Usage Notes

For queues created in 8.1-compatible queue tables, this view provides functionality that is equivalent to the dbms_aqadm.queue_subscribers() procedure. For these queues, it is recommended that the view be used instead of this procedure to view queue subscribers.