OraFAQ Forum: Streams & AQ » View payload contents of a msg in a queue?

Home » Server Options » Streams & AQ » View payload contents of a msg in a queue?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

View payload contents of a msg in a queue? [message #302430]

Mon, 25 February 2008 11:15

alp0001
Messages: 29
Registered: September 2005
Location: Illinois, USA

Junior Member

How do you view the contents of the payload of a msg in a queue (via PL/SQL) without actually dequeing it (Oracle 10)? Is there a way based on the msg_id that is available? We need to see what type of payload is causing the msg to stay on the queue for production support monitoring.

Report message to a moderator

Re: View payload contents of a msg in a queue? [message #302436 is a reply to message #302430]

Mon, 25 February 2008 11:57

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Query the queue table.

regards
Michel

Report message to a moderator

Re: View payload contents of a msg in a queue? [message #302440 is a reply to message #302430]

Mon, 25 February 2008 12:11

alp0001
Messages: 29
Registered: September 2005
Location: Illinois, USA

Junior Member

I will ask our DBAs as payload isn't a column that is available -> only msg_id and enq_time are the only columns currently available.

Report message to a moderator

Previous Topic:	Recipientlist (Connection with Java)
Next Topic:	dequeue from AQ

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 16:43:27 CST 2024