Re: Any idea for field w/ greater than 255 bytes?
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/07/31
Message-ID: <3vij44$98h_at_ixnews6.ix.netcom.com>#1/1
Date: 1995/07/31
Message-ID: <3vij44$98h_at_ixnews6.ix.netcom.com>#1/1
thorn_at_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 Received on Mon Jul 31 1995 - 00:00:00 CEST