topic Re: can not read my geometry field on an Oracle database in Talend Studio https://community.qlik.com/t5/Talend-Studio/can-not-read-my-geometry-field-on-an-Oracle-database/m-p/2205074#M5687 hi,<BR />can you convert your fields to String into your Select query?<BR />Regards,<BR /> Thu, 28 Feb 2019 10:38:23 GMT fdenis 2019-02-28T10:38:23Z can not read my geometry field on an Oracle database https://community.qlik.com/t5/Talend-Studio/can-not-read-my-geometry-field-on-an-Oracle-database/m-p/2205073#M5686 <P><SPAN>Hello,</SPAN></P><P>&nbsp;</P><P><SPAN>I can not read my geometry field on an Oracle database, </SPAN></P><P>&nbsp;</P><P><SPAN>can you please help me please</SPAN></P> Sat, 16 Nov 2024 06:27:51 GMT https://community.qlik.com/t5/Talend-Studio/can-not-read-my-geometry-field-on-an-Oracle-database/m-p/2205073#M5686 Anonymous 2024-11-16T06:27:51Z Re: can not read my geometry field on an Oracle database https://community.qlik.com/t5/Talend-Studio/can-not-read-my-geometry-field-on-an-Oracle-database/m-p/2205074#M5687 hi,<BR />can you convert your fields to String into your Select query?<BR />Regards,<BR /> Thu, 28 Feb 2019 10:38:23 GMT https://community.qlik.com/t5/Talend-Studio/can-not-read-my-geometry-field-on-an-Oracle-database/m-p/2205074#M5687 fdenis 2019-02-28T10:38:23Z Re: can not read my geometry field on an Oracle database https://community.qlik.com/t5/Talend-Studio/can-not-read-my-geometry-field-on-an-Oracle-database/m-p/2205075#M5688 <P><A href="https://community.qlik.com/s/profile/0053p000007LPH9AAO">@didi</A>&nbsp;&nbsp;</P> <P>You need to convert your Geometry column to verticles before reading it in Talend.</P> <P>&nbsp;</P> <P>Trt this in tOracleInput&nbsp;</P> <P>&nbsp;</P> <P>"select ts.x lon ,ts.y lat from <U><EM><STRONG>yourtable</STRONG> </EM></U>,table(sdo_util.getvertices(<U><EM><STRONG>yourGeoColumn</STRONG></EM></U>)) ts "&nbsp;</P> <P>&nbsp;</P> <P>Read these column as double.</P> <P>&nbsp;</P> <P>As you dealing with Geometry Data , below would helpful&nbsp;</P> <P>&nbsp;</P> <P><A href="https://www.talend.com/blog/2017/08/07/how-to-seamlessly-include-geospatial-data-and-operations-into-your-data-integration-process/" target="_blank" rel="nofollow noopener noreferrer">https://www.talend.com/blog/2017/08/07/how-to-seamlessly-include-geospatial-data-and-operations-into-your-data-integration-process/</A></P> <P>Hope this will help.</P> Thu, 28 Feb 2019 11:08:14 GMT https://community.qlik.com/t5/Talend-Studio/can-not-read-my-geometry-field-on-an-Oracle-database/m-p/2205075#M5688 akumar2301 2019-02-28T11:08:14Z