Dynamic schema and oracle spatial data sdo_geometry

One Star

Dynamic schema and oracle spatial data sdo_geometry

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,
Community Manager

Re: Dynamic schema and oracle spatial data sdo_geometry

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Dynamic schema and oracle spatial data sdo_geometry