Convert Long to Varchar

[Fred]

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

[Frank van Bortel]

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