topic Re: Dynamic schema and oracle spatial data sdo_geometry in Talend Studio

Dynamic schema and oracle spatial data sdo_geometry

Anonymous — Sat, 16 Nov 2024 12:33:01 GMT

Hi !
we use
"Talend Integration Suite - Team Edition"
Version: 4.1.2
Build id: r53616-20110106-0535
We have to copy database from our intranet to our extranet.
We use a tOracleInput conpenent with a dynamic schema. It is link to tOracleOutput with a dynamic schema. Some tables have columns with sdo_geometry data type.
When we run our job we have this error : "ORA-00932: inconsistent data types; expected: MDSYS.SDO_GEOMETRY; obtained: CHAR"

I try to modified the talend mapping_Oracle.xml file to add data type SDO_GEOMETRIE but it doesn't work in dynamic mode. It seems that the dynamic mode does not take into account this parameter file.
Can we use dynamic schema with sdo_geometry ? If yes, wich version we must use ? If no, how could we do our database copy ?
Thanks for your interest,

Re: Dynamic schema and oracle spatial data sdo_geometry

Anonymous — Fri, 25 Nov 2011 00:25:37 GMT

When we run our job we have this error : "ORA-00932: inconsistent data types; expected: MDSYS.SDO_GEOMETRY; obtained: CHAR"

It should be a bug here, the target data type is Char instead of MDSYS.SDO_GEOMETRY. Please report a bug on our bugtracker.
Best regards
Shong

Re: Dynamic schema and oracle spatial data sdo_geometry

Anonymous — Fri, 25 Nov 2011 08:44:47 GMT

bug open : http://jira.talendforge.org/browse/TDI-18695

Re: Dynamic schema and oracle spatial data sdo_geometry

vrobine — Fri, 07 Aug 2020 08:39:21 GMT

Hi,

Do you have any answers since 9 years ?

Thanks,

Vincent