SQL Stored Proc. XML to JDBC Sender Channel - XML is mashed ..

[Former Member]

Ive written aStored proc to build a nested XML stucture for sales with header/lines/payment/notes and so on. Unfortunately joining this data in a traditional select just wont work, now I have my XML structure returned - I go to the sender adapter and it builds me a <row> tag with my XML but the < and > have been escaped out to be ;gt and ;lt.

How do I get this data back into a usable format ?

I was thinking I use a UDF to pull the data from the ROW tag and do somekind of replace on the ;gt to remove the escaping ....

so coming in I have;

<MT_SALES>

     <row>;gtTAG1;Tag_data;gt;....... bl;ah blah blah</row>

</MT_SALES>

I what I want out of that is just the stuff out of <row> into an processable XML document ?????

How do I do this ?

Thanks

[allamudi_loordh]

Hi Richard,

can you please explain properly your question..

Regards,

Loordh.