Dynamic schema and oracle spatial data sdo_geometry

[Anonymous]

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,

[Anonymous]

Hi

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

[Anonymous]

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

[vrobine]

Hi,

Do you have any answers since 9 years ?

Thanks,

Vincent