I am trying to move over a table that has images in it, and I am having some issues. I have done:
1) Data Unload to XML in Apex 3.2
2) Data Load from XML in Apex 4.1
Everything but the blobs are working fine.
I tried this to compare the two: select dbms_lob.substr(image, 50, 1):
In 3.2: FFD8FFE000104A4649460001010100B400B40000FFE10C4C45786966000049492A000800000007000F010200060000006200:
In 4.1: 4646443846464530303031303441343634393436303030313031303130304234303042343030303046464531304334433435
The text in the XML is the same as the 3.2, so it doesn't look like 3.2 it is encoding it at all, and maybe 4.1 is decoding? I am not too sure.
In 4.1, I did select utl_raw.cast_to_varchar2(dbms_lob.substr(image, 50, 1)) and got:
So it seems like maybe it cast the raw to a raw, thinking it was a varchar? I have tried a few things to fix this, but I have been running into buffer size errors when trying. Does anyone have any idea as to what I should do?
I have just exported from 4.1, and like 3.2, the export (data unload) matches what dbms_lob.substr returns to me, but when I import it (data load) the data gets altered more.
I noticed that it was initially full of hex values, but after the first conversion, it become all decimal values. Does anyone have a fix or workaround for this bug?