Display contents of Oracle AQ SYS.AQ$_JMS_TEXT_MESSAGE

oracle jms advanced-queuing
Bruno Ranschaert picture Bruno Ranschaert · Jun 19, 2009 · Viewed 23.9k times · Source

I have an application that uses JMS op top of Oracle advanced queuing. I would like to do a query on the queue table that shows the content of the message (which in my case is XML). So when I do a 'select user_data from [queue_table]' I get 'AQ SYS.AQ$_JMS_TEXT_MESSAGE' as a response.

Is there a function so that the contents of this message can be shown? Something like 'select FUNCTION(user_data) from [queue_table]' or something?

I googled, scanned numerous Oracle articles about queuing, but I cannot find this thing. I suspect there is a simple way to do this, but I cannot find it.

Answer

Rob van Wijk picture Rob van Wijk · Jun 20, 2009

I struggled with this one as well. I've written an answer here: http://rwijk.blogspot.com/2009/02/whats-in-my-jms-queue.html .

Regards, Rob.

Related questions

How to clear a queue in Oracle AQ

I've been testing Oracle AQ for the first time. I have managed to create 2000 rows of test inserts into the queue I created. Now, I'd like to clear those out. As I was teaching myself, I set the expiry time …

Read More
Is there a fast way to clear Exception queue from Oracle AQ?

AQ$_MESSAGES_EXCEPTIONFirst of all I know there's this question: How to clear a queue in Oracle AQ but it doesn't have an answer. I have a lot of messages(500k) in the exception queue in the Oracle AQ(I …

Read More
Show me an simple example of Oracle Streams?

I am just getting started with on a project and hope to use Oracle streams. I am looking for a straight-forward, hello-world type of example using Oracle Streams. Can you point me to a tutorial or show me an example? …

Read More