One Star

[resolved] Please give me help with oracle blob?

First,I have read photo image file as string and encode based on base64,then I want to insert this string to oracle blob column,I used decode_base64 to decode this string,and then use map component directly insert the string to blob column,when I run,this error occurs:
DBD:Smiley Surprisedracle::st execute failed: ORA-01461: can bind a LONG value only for insert into a LONG column
But when I use the same method to write to Mysql Blob,it works fine.
Can someone give me some suggest,thx!
1 ACCEPTED SOLUTION

Accepted Solutions
Community Manager

Re: [resolved] Please give me help with oracle blob?

I have the file .jpeg. I want insert the images into the table of my BD oracle. Could you help me?

Please refer to DataImpact's solution in this page:
http://www.talendforge.org/forum/viewtopic.php?id=1753
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
3 REPLIES
One Star

Re: [resolved] Please give me help with oracle blob?

I have the file .jpeg. I want insert the images into the table of my BD oracle. Could you help me?
Community Manager

Re: [resolved] Please give me help with oracle blob?

I have the file .jpeg. I want insert the images into the table of my BD oracle. Could you help me?

Please refer to DataImpact's solution in this page:
http://www.talendforge.org/forum/viewtopic.php?id=1753
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Please give me help with oracle blob?

Thank you, I can import the picture in my table.