I'm using soap to enqueue/dequeue message from my aq queue table;
I used utl_http package to post soap to my AQServlet. This procedures worked fine when i used only varchar2(32767) variable which write text to AQServlet. This wasn't good enough because i have to send larger amounts of data in soap. So i used clob to enqueue data in my queue.
This work's , and i can see all data in my queue table which has column for data of xmltype. But when i try to dequeue data using soap i got this error:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of 'E'
This is how my soap looks like:
<?xml version="1.0"?>
<Envelope xmlns="http://ns.oracle.com/AQ/schemas/envelope">
<Body>
<AQXmlReceive xmlns = "http://ns.oracle.com/AQ/schemas/access">
<consumer_options>
<destination>PROBA_AQADM.NAD_Q</destination>
<consumer_name>CONSUMER</consumer_name>
<selector>
<condition> tab.corrid='spanish'</condition>
</selector>
<dequeue_mode>REMOVE</dequeue_mode>
</consumer_options>
<AQXmlCommit>
</AQXmlCommit>
</AQXmlReceive>
</Body>
</Envelope>
I can't figure it out why is this hapening!
Do i have to put some more tab in my xml/soap message?