Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!news3.optonline.net!newsfeed.kabelfoon.nl!news2.euro.net!newsgate.cistron.nl!skynet.be!skynet.be!newsfeed00.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail From: Lothar Armbruester Newsgroups: comp.databases.oracle.server Subject: Re: BLOB -> CLOB conversion Date: Tue, 11 Nov 2003 18:17:08 +0100 Organization: T-Online Lines: 19 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.t-online.com 1068571097 08 27718 rM45V66rnyKYhrx 031111 17:18:17 X-Complaints-To: usenet-abuse@t-online.de X-ID: VPy3gyZHYeOFjPKicG678vrazgOhdppEBs+ViOVk-O24lywYtJuTs9 User-Agent: Pineapple News 0.9.9 [PLAID BETA], BeOS (Intel) 5.0.3 X-Program-URL: http://www.beosdevelopers.org/brunsona/pineapplenews.html X-Registered-To: Lothar Armbruster Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:247454 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@oktagramm.de Hauptstr. 26 | la@heptagramm.de D-65346 Eltville | lothar.armbruester@t-online.de