Selecting Queue Subscribers

Figure 10-12 Use Case Diagram: Selecting Queue Subscribers

Text description of the illustration adq10qvw17.gif

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. This view also displays the transformation for the subscriber if it was created with one.

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
TRANSFORMATION--the name of the transformation can be null		VARCHAR2(61)

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.