topic Re: XML_Type Data Transfer from Oracle source to Oracle Target table in Talend Studio

XML_Type Data Transfer from Oracle source to Oracle Target table

Anonymous — Tue, 13 Mar 2018 13:19:38 GMT

Hi all,

In my table have one column datatype XMLTYPE and data like this <row id='12' xml:space='pre'><c1>12</c1><c2>23</c2><c3>34</c3><c4>45</c4><c5>56</c5></row>. How can i transfer the data from Oracle to Oracle table. Actually my Output table have XMLTYPE datatype column.

Design:
toracleInput --> toracleoutput

Re: XML_Type Data Transfer from Oracle source to Oracle Target table

Anonymous — Tue, 27 Mar 2018 10:15:17 GMT

Hello,

In your oracle source, you can use EXTRACTVALUE() EXTRACT() and so on.
like ELECT extract(xmltypetest, '/PurchaseOrder/ShippingInstructions')
FROM xmltype_test.

And for target table, tOracleOutput supports Object-->XMLType mapping.

Let us know if it is OK with you.

Best regards

Sabrina