How to convert substring from a BLOB to readable characters?

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