I am trying to move XML data that is stored in an Oracle 11 database as type XMLTYPE to anything else. I would be fine with simply being able to export into a delimited text file. The problem being I do not see where or how to allow Talend to loop thru the XML document as an XML document.
I have ran into a wall trying to process an XMLTYPE Oracle document from Oracle. I can not find anywhere that shows how to parse thru the stored XML document.
I found one post that was directed towards creating the XMLTYPE but nothing about pulling data out.
This is the Oracle schema / DDL
ouput_row.XML_DOCUMENT = new String(input_row.XML_DOCUMENT)
output_row.GO_XML = new String(input_row.GO_XML);
extractvalue(XML_DOCUMENT, '/cds-mistint/tt_cds-mistint/store-nbr/text()') as STORE_NBR,
extractvalue(XML_DOCUMENT, '/cds-mistint/tt_cds-mistint/control-nbr/text()') as CONTROL_NBR,
extractvalue(XML_DOCUMENT, '/cds-mistint/tt_cds-mistint/line-nbr/text()') as LINE_NBR,
extractvalue(XML_DOCUMENT, '/cds-mistint/tt_cds-mistint/sales-nbr/text()') as SALES_NBR
where GUID = 'PRIMARY_KEY'