Selecting Messages in Queue Table

Figure 10-8 Use Case Diagram: Selecting Messages in Queue Table

Text description of the illustration adq10qvw13.gif

Name of View

Select messages in Queue Table.

Purpose

This view describes the queue table in which message data is stored. This view is automatically created with each queue table and should be used for querying the queue data. The dequeue history data (time, user identification and transaction identification) is only valid for single consumer queues.

Table 10-8  View for Selecting Messages in a Queue Table

Column Name & Description	Null?	Type
QUEUE--queue name		VARCHAR2(30)
MSG_ID--unique identifier of the message		RAW(16)
CORR_ID--user-provided correlation identifier		VARCHAR2(128)
MSG_PRIORIT--message priority		NUMBER
MSG_STATE--state of this message		VARCHAR2(9)
DELAY--number of seconds the message is delayed		DATE
EXPIRATION--number of seconds in which the message will expire after being READY		NUMBER
ENQ_TIME-- enqueue time		DATE
ENQ_USER_ID--enqueue user id		NUMBER
ENQ_TXN_ID--enqueue transaction id	NOT NULL	VARCHAR2(30)
DEQ_TIME--dequeue time		DATE
DEQ_USER_ID--dequeue user id		NUMBER
DEQ_TXN_ID--dequeue transaction id		VARCHAR2(30)
RETRY_COUNT--number of retries		NUMBER
EXCEPTION_QUEUE_OWNER--exception queue schema		VARCHAR2(30)
EXCEPTION_QUEUE--exception queue name		VARCHAR2(30)
USER_DATA--user data		BLOB
SENDER_NAME--name of the Agent enqueuing the message (valid only for 8.1-compatible queue tables)		VARCHAR2(30)
SENDER_ADDRESS--queue name and database name of the source (last propagating) queue; the database name is not specified if the source queue is in the local database (valid only for 8.1-compatible queue tables)		VARCHAR2(1024)
SENDER_PROTOCOL--protocol for sender address, reserved for future use (valid only for 8.1-compatible queue tables)		NUMBER
ORIGINAL_MSGID--message id of the message in the source queue (valid only for 8.1-compatible queue tables)		RAW(16)
CONSUMER_NAME--name of the Agent receiving the message (valid ONLY for 8.1-compatible MULTICONSUMER queue tables)		VARCHAR2(30)
ADDRESS--address (queue name and database link name) of the agent receiving the message.The database link name is not specified if the address is in the local database. The address is NULL if the receiving agent is local to the queue (valid ONLY for 8.1-compatible multiconsumer queue tables)		VARCHAR2(1024)
PROTOCOL--protocol for receiving agent's address (valid only for 8.1-compatible queue tables)		NUMBER
PROPAGATED_MSGID--message id of the message in the receiving agent's queue (valid only for 8.1-compatible queue tables)	NULL	RAW(16)
ORIGINAL_QUEUE_NAME--name of the queue the message came from
ORIGINAL_QUEUE_OWNER--owner of the queue the message came from
EXPIRATION_REASON--the reason the message came into the exception queue. Possible values are TIME_EXPIRATION (message expired after the specified expired time), MAX_RETRY_EXCEEDED (max. retry count was exceeded), and PROPAGATION_FAILURE (message became undeliverable during propagation)