Fred wrote:[color=blue]
> 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[/color]
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
