OraFAQ Forum: Streams & AQ » SYS.AQ$_JMS_TEXT_MESSAGE type...how to look at values

Home » Server Options » Streams & AQ » SYS.AQ$_JMS_TEXT_MESSAGE type...how to look at values

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 17:44:11 CST 2024