Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to convert substring from a BLOB to readable characters?

How to convert substring from a BLOB to readable characters?

From: Harry Bakker <Harry.Bakker_at_nl.abnamro.com>
Date: 3 Apr 2003 06:52:25 -0800
Message-ID: <63580f9f.0304030652.448a7b2f@posting.google.com>


I need to extract a substring from a BLOB using a PL/SQL program. To extract the substring from the BLOB, i'm using the dmbs_lob.substr() function. Problem is that it gives me a string in hexadecimal characters back, while i need the string to be in readable ascii format.

Does someone know how to do such a conversion?

Thanks in advance,

-Harry Bakker Received on Thu Apr 03 2003 - 08:52:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US