How to convert varchar2 binary data to BLOB and append blob data
5578May 13 2005 — edited May 16 2005Hi,
We have oracle 9i rel 2.
We have a picture that will be sent as binary data in a varchar2 column. I need to write a stored procedure that will take this as an input parameter and update a blob column.
The stored procedure will be executed many times in a loop depending on the size of the picture.
The picture is stored in SAP(v 4.6C)which does not support blobs
which is why it is put in a table as varchar2.
Can anyone tell me how to convert varchar2 to blob and update a blob column.
Also, I need to append to the existing blob column.
Help appreciated.
Mala.Kaushik