Dynamic schema and oracle spatial data sdo_geometry

Highlighted
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,
Highlighted
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
Highlighted
One Star

Re: Dynamic schema and oracle spatial data sdo_geometry

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog