How to transfer MySQL MediumBLOB to Oracle BLOB
Hi all,
I'm an ODI beginner and try to transfer a small MySQL learning database into an Oracle database schema. Everything works fine (more or less) until I met the first table containing a BLOB, i.e. the MySQL tables contains a MEDIUMBLOB and the column in accordance with at Oracle site is defined as BLOB. (Tried CLOB also, because of there are only ASCII Characters inside that MEDIUMBLOB, but without success.)
I tested n+1 different ways and got n+ 1 different errors! I downloaded LKM_SQL_to_Oracle_(CLOB)_v1 and LKM_SQL_to_Oracle_Lob_v2 and got new errors.
I would be very please if someone could help me. Because this is only a test environment to exercise the handling and learn about concepts of ODI, I'm free to test any reasonable recommendation.
Thanks in advance,
Lucie