Home » Server Options » Streams & AQ » View payload contents of a msg in a queue?
View payload contents of a msg in a queue? [message #302430] Mon, 25 February 2008 11:15 Go to next message
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.
Re: View payload contents of a msg in a queue? [message #302436 is a reply to message #302430] Mon, 25 February 2008 11:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query the queue table.

regards
Michel
Re: View payload contents of a msg in a queue? [message #302440 is a reply to message #302430] Mon, 25 February 2008 12:11 Go to previous message
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.
Previous Topic: Recipientlist (Connection with Java)
Next Topic: dequeue from AQ
Goto Forum:
  


Current Time: Thu Mar 28 09:18:18 CDT 2024