Re: Convert Long to Varchar
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 16 Aug 2004 10:55:39 +0200
Message-ID: <cfpsec$lnj$1_at_news1.tilbu1.nb.home.nl>
Date: Mon, 16 Aug 2004 10:55:39 +0200
Message-ID: <cfpsec$lnj$1_at_news1.tilbu1.nb.home.nl>
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 BortelReceived on Mon Aug 16 2004 - 10:55:39 CEST