Blob data Insertion

Anonymous — Tue, 18 Apr 2017 06:45:34 GMT

Hi,

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.

Please revert.

Thanks in advance.

Regards,

Sangram

Re: Blob data Insertion

Anonymous — Wed, 19 Apr 2017 00:46:00 GMT

Hi @rchinta, I suspect that this post (https://community.talend.com/t5/Design-and-Development/resolved-Create-file-from-a-blob-input-oracle-db/td-p/92265) 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.