Re: converting CLOB into VARCHAR2?

When you read a clob, you read it based on a buffer size, and t you read it in to a eg varchar2(4000), this should be the way you would convert the clob in to varchar.
Tom

Jeffrey Boulier <jeffreyb_at_gwu.edu> wrote in message news:fllP4.1816$D8.15096_at_grover.nit.gwu.edu...
>
> Hi folks,
>
> After doing a few max(dbms_lob.getlength())s on our CLOB
> fields, we've discovered that there are quite a few that should be
> VARCHAR2(4000) instead . What would be the best way to convert them?
> Is there a way that gets around using DBMS_LOB.READ? How should
> I compare a CLOB and a VARCHAR2?
>
> Thanks for any help you can give!
>
> Yours Truly,
> Jeffrey Boulier
> --
> _ __ _ _ ___ _ __ ___| |_| |_ ___ _ _ ___ Senior Programmer/Analyst
> | '_ \ '_/ _ \ ' \/ -_) _| ' \/ -_) || (_-< www.prometheus.com
> | .__/_| \___/_|_|_\___|\__|_||_\___|\_,_/__/ George Washington University
> |_|
Received on Tue May 02 2000 - 00:00:00 CDT