I am using Talend DI 6.3.0 tool for data migration from oracle 12c to oracle 12C databases.
Blob field contains binary data.
I have tried & tested by mapping ,Blob as type Object (or byte ) in source and destination database, (As it answered in one of your forum)
But Its failing whenever I am migrating blob related columns. Getting following error:
ORA-00932: inconsistent datatypes: expected CHAR got BLOB.
FYI, I am using tOracleInput and tOracleOutput component.
Thanks in advance.
Hi @sangram111, I suspect that this post (https://www.talendforge.org/forum/viewtopic.php?id=43880) may help you out. It is from a while ago, but I believe it is still relevant. Keep in mind that this is related to an image stored as a blob. The solution should be able to be extrapolated from.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables