From: chuckh@ix.netcom.com (Chuck Hamilton)
Subject: Re: Any idea for field w/ greater than 255 bytes?
Date: 1995/07/31
Message-ID: <3vij44$98h@ixnews6.ix.netcom.com>#1/1
distribution: world
references: <3vaudb$obg@hecate.umd.edu>
organization: Netcom
newsgroups: comp.databases.oracle


thorn@w3eax.umd.edu (Greg KD3SU) wrote:

>I am trying to have one column for a comment (string) in a table
>that is greater than 255. I tried to use LONG but it does
>not work. The book says a LONG can hold up to 2 gigabytes of
>info. Anyone have any ideas? The error I get says :
 
>Field in data file exceeded maximum specified length
 
>Is there another datatype that I might be able use that I'm not
>aware of?

There's a system variable that limits the display length of a LONG in
SQLPlus called "LONG". Try setting that to a higher value. Ex. SET
LONG=5000.

HTH