[resolved] Please give me help with oracle blob?

[Anonymous]

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: racle::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!

[Anonymous]

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

[Anonymous · Accepted solution]

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:
https://community.talend.com/t5/Design-and-Development/resolved-File-into-BLOB/td-p/67476
Shong

[Anonymous]

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