Please anybody search blob converter?

Asked By Timothy Raine 40 points N/A Posted on - 01/28/2013

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.

• Status: Open
• Question Views: 834
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Waall Mike 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

About Waall Mike

Questions
20

Answers
220

Best Answers
62

• Vote Up 0 Vote Down

• Posted on - 01/31/2013
• Question Category: Oracle Database