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

DA Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3E8C63FA.A05A1D34_at_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

Thanks everybody!

The utl_raw.cast_to_varchar2() really did it for me!

Cheers,

-Harry Received on Fri Apr 04 2003 - 03:54:51 CST