Administrative Interface: Views, 9 of 16

Select Messages in Queue Table

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

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:

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 Select Messages in 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_PRIORITY -- 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)`