Re: LONG data type questions

In <3m1d6n$pdp$1_at_mhadf.production.compuserve.com> Jay D. Sullivan <70614.42_at_CompuServe.COM> writes:

>
>I'm trying to use the LONG data type for the first time and I'm
>having a few problems. It seems to only be storing a maximum of
>256 characters. When I issue an INSERT statement with a 300
>character string, the insert seems to work but when I select the
>data back to make sure that it worked, I only get 256 characters
>back.
>
>Also, once I get this fixed, is there any way to only select a
>substring of the LONG data type without using the Oracle Call
>Interface?
>
>--
>Jay D. Sullivan
>Economic Analysis Group, Ltd.
>jsulliva_at_eag.mhs.compuserve.com
>

Are you doing this in SQL*PLUS? If yes then issue SET LONG 3000 (or any number higher than 300), you'll see all 300 characters. Received on Fri Apr 07 1995 - 00:00:00 CEST