Querying Oracle Advanced Queuing to see text messages through SQL

To see character data in an Oracle Advanced Queuing using SQL.
use the following query

select q.USER_DATA.TEXT_LOB from schema.AQTableName q

make a SOA 10 g BPEL Process not to dehydrate any data at a Process level and not at Domain Level

To make a SOA 10 g BPEL Process not to dehydrate any data at a Process level and not a domain Level.

This can be done by simply adding an entry into bpel.xml

<configurations>
<property name="inMemoryOptimization" encryption="plaintext">true</property>
<property name="completionPersistLevel" encryption="plaintext">instanceHeader</property>
<property name="completionPersistPolicy" encryption="plaintext">off</property>
<property name="deliveryPersistPolicy" encryption="plaintext">off</property>
</configurations>