Home » Server Options » Streams & AQ » SYS.AQ$_JMS_TEXT_MESSAGE type...how to look at values
SYS.AQ$_JMS_TEXT_MESSAGE type...how to look at values [message #268106] Mon, 17 September 2007 09:21
frankel
Messages: 16
Registered: September 2005
Junior Member
I created a before row trigger on the WF_WS_JMS_OUT queue and need to look at the payload values in the USER_DATA that is of SYS.AQ$_JMS_TEXT_MESSAGE type.

How can I do that? It seems to have member functions to look at the payload data, but I don't understand how to use them and there is no documentation on it. I want to look at the property values and get the names of those properties.

Any help would be appreciated. Thanks!

-Jason

[Updated on: Mon, 17 September 2007 09:30]

Report message to a moderator

Previous Topic: Streams only for insert statement
Next Topic: Rollback JMS message ?
Goto Forum:
  


Current Time: Tue Jul 22 02:44:02 CDT 2014

Total time taken to generate the page: 0.05207 seconds