N/APosted on - 01/28/2013
I have a BLOB(binary large object) datatype field in my database and i wish to store blob datatype into a string datatype field.But first I must convert blob datatype into string datatype.
I have search blob converter,but could not gather much information from the internet.So,friends please provide me the effective solution to convert blob to string datatype.
Please anybody search blob converter?
Hello there Timothy,
I understand that you have been researching for your problem but none of them works for you.
But have you tried the resolution posted in stack overflow for blob to string conversion for oracle?
If not, you may want to check it out and here's the link for the website. You need to put in these following commands :
Select utl_raw. cast_to_varchar2 (dbms_lob. substr (BLOB_FIELD)) from TABLE_WITH_BLOB where ID = '<row id>';
Hope this helps you.