Re: BLOB -> CLOB conversion

Jeremy wrote:
> If you have a BLOB which you know contains only char data, how do you
> read that into a CLOB in PL/SQL so that you can perform (limited in
> 8.1.7) string functions on it?
>
> (8.1.7)
>

Hello Jeremy,

I don't know if it's in 8.1.7 already but in 9i there is an utl_raw package that can can convert raw to varchar2 and vice versa.

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de