Please anybody search blob converter?

Asked By 40 points N/A Posted on -
qa-featured

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.

Thanks.

SHARE
Answered By 265 points N/A #185019

Please anybody search blob converter?

qa-featured

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