Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-04-18 02:45 AM

Blob data Insertion

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

 

 

 

 

Labels (2)
Labels
241 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2017-04-18 08:46 PM
Author

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

241 Views
0 Likes