https://community.qlik.com/t5/Talend-Studio/How-to-retrieve-XML-Instance-type-Oracle-in-tdbinput/m-p/2234807#M24038 <P>Error is resolved using escape sequence \ before " . But its not fetching data ,even when data is present in that field.</P> Sat, 02 Nov 2019 17:57:08 GMT Anonymous 2019-11-02T17:57:08Z https://community.qlik.com/t5/Talend-Studio/How-to-retrieve-XML-Instance-type-Oracle-in-tdbinput/m-p/2234806#M24037 <P>I need to execute below query in tdbinput (Oracle) :</P> <P>"</P> <P>select extractValue(fc.data_xml,'/ns0:Customer/name ','xmlns:ns0="<A href="http://www.w3org.com/DataModel/Object/Customer" target="_blank" rel="nofollow noopener noreferrer">www.w3org.com/DataModel/Object/Customer</A>"') name from customer fc</P> <P>";</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>But its failing with syntax error because of "" and ' tokens .&nbsp;<BR /><BR />How to execute this query in tdbinput</P> Sat, 02 Nov 2019 08:56:50 GMT https://community.qlik.com/t5/Talend-Studio/How-to-retrieve-XML-Instance-type-Oracle-in-tdbinput/m-p/2234806#M24037 Anonymous 2019-11-02T08:56:50Z https://community.qlik.com/t5/Talend-Studio/How-to-retrieve-XML-Instance-type-Oracle-in-tdbinput/m-p/2234807#M24038 <P>Error is resolved using escape sequence \ before " . But its not fetching data ,even when data is present in that field.</P> Sat, 02 Nov 2019 17:57:08 GMT https://community.qlik.com/t5/Talend-Studio/How-to-retrieve-XML-Instance-type-Oracle-in-tdbinput/m-p/2234807#M24038 Anonymous 2019-11-02T17:57:08Z