Hello,
I have attempted to export rows from query with BLOB columns and developer generated insert command looks like this
Insert into my_table (ID,blob_column) values (55,TO_BLOB(HEXTORAW('626567696E2030207575656E636F64652E6275660D0A6C34244C23212130202140202820202020283021212D5E2A20464C32'))
|| TO_BLOB(HEXTORAW('2E3C40242020203025202020332020402236542D4F3B4731453B47313F3527455039372D3D2B47414D3B22232B462030220D'))
|| TO_BLOB(HEXTORAW('0A6C2A2C2A402020282020202020202020202020202020202020202020202020202020202020202020202020202020202020'))
..
|| TO_BLOB(HEXTORAW('2050202025223420202020200D0A0A656E64')));
But insert failed with error
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected CHAR got BLOB
The problem is probably with concatenating TO_BLOB - I think this is not allowed.
Or exists any other explanation for this error?
Thanks.
Marian