Please anybody search blob converter?

Asked By 40 points N/A Posted on -

Hello Friends,

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.


Answered By 270 points N/A #185019

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.

Waall Mike

Login/Register to Answer

Related Questions