Re: How to convert substring from a BLOB to readable characters?

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Thu, 03 Apr 2003 08:40:26 -0800
Message-ID: <3E8C63FA.A05A1D34@exxesolutions.com>

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