Re: INSERT INTO a LONG datatype

From: Patricia McCreary <pattimcc_at_sdsc.edu>
Date: 1996/04/03
Message-ID: <3162F079.2781E494_at_sdsc.edu>#1/1


If LONG gets set, it's only set for that particular session, right? Is there a way to permently set LONG? I'm using SQL*Loader and eventhough I've set my LONG to 20000 (definitely big enough) I still get this error.

Field in data file exceeded maximum specified length

Thanks in advance for any help.

>
> Try the "SET LONG" option to change the size of longs in Sqlplus for insert/
> copy/select.
>
> eg. SQL> set long 5000
>
> Bye
> Georgia
Received on Wed Apr 03 1996 - 00:00:00 CEST

Original text of this message