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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download