Re: Convert Long to Varchar

Fred wrote:
> Hi all,
>
> I have a nice problem. I´m trying to convert a Long to varchar2. It
> works when the long field doesn´t contain more than 2000 characters.
> How do I solve this?
>
> I´m working with Oracle 7 by the way.
>
> /Fred

SQL or PL/SQL?
SQL: try "set long <an arbitrary large value>" PL/SQL: a varchar variable holds 4k/32k max, so you are stuck. 32k when you just want to use it, 4k when you want to interface with it (e.g. store in a table)

-- 

Regards,
Frank van Bortel