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,