Re: HELP: not LONG enough ?????

From: TurkBear <jvgreco_at_pop.primenet.com>
Date: 1997/10/15
Message-ID: <34452f38.1262255@news.primenet.com>#1/1

LONG will handle much larger than 4000 - how are you loading the data?
If you are using SqlLoader check the docs for how to specify the max length for long.

Hope it helps

John Greco
Oracle DBA

"Michael Bruyninckx" <mich_at_imagic.be> wrote:

>Hi folks,
>
>I need to store blocks of +-4000 characters in a table... I tried
>VARCHAR2(2000), which is aparantly the maxlength of the datatype VARCHAR2,
>I also tried LONG but 4000 chars seems to be too much...
>
>How can I solve this problem ?
>
>Michael
Received on Wed Oct 15 1997 - 00:00:00 CDT