I am trying to retrieve a CLOB from a SYS.AQ$_JMS_MESSAGE that is currently on a queue. I tried dequeuing as an AQMessage, but after interrogating the object, cannot find the CLOB (CLOB contains xml text).
I get what I want using the following SQL:
, qt.user_data.text_lob from EVENT_MSG_TBL qt
where q_name = 'EVENTQUEUE';
(qt.user_data.text_lob has the XML I am looking for)
I need the equivalent of this in Java. Can anyone help?