Select from ORACLE XMLTYPE Datatype to any ouput. getDocument
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
I get this error when trying to perform the following.
how to extract xml data from xml type column in database table as input and those xml data need to insert some other tables in database as output please help me to find this
