Convert OLE BLOB data type back to original BLOB
Posted on 2004-04-12
I have a problem here. My senior was using a program to update some images (JPEG) file into Oracle database table as BLOB data type. According to him, he was using OLE which cause a problem in reading it now. He said that is because when we use OLE , the OLE will add extra information/codes in front and at the back of the BLOB. That's why when we try to convert it back to original BLOB, problem occured.
My question is, what is the easiest way to convert BLOB data in my table back to original BLOB data by removing that piece of codes from the BLOB.
Please provide me the source code. Thanks first for your help.