Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to convert substring from a BLOB to readable characters?
Harry Bakker wrote:
> 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
Vladimir is correct with respect to your column being a BLOB. But if the point of the column is to hold text you are using the wrong data type: Convert to CLOB.
Daniel Morgan Received on Thu Apr 03 2003 - 10:40:26 CST
![]() |
![]() |