can not read my geometry field on an Oracle database

[Anonymous]

Hello,

I can not read my geometry field on an Oracle database,

can you please help me please

[fdenis]

hi,
can you convert your fields to String into your Select query?
Regards,

[akumar2301]

@didi  

You need to convert your Geometry column to verticles before reading it in Talend.

Trt this in tOracleInput 

"select ts.x lon ,ts.y lat from yourtable ,table(sdo_util.getvertices(yourGeoColumn)) ts " 

Read these column as double.

As you dealing with Geometry Data , below would helpful 

https://www.talend.com/blog/2017/08/07/how-to-seamlessly-include-geospatial-data-and-operations-into...

Hope this will help.