Re: Q: Sql*Loader maximum record length

In article <6olhnl$fm_at_panix.com>,

        WeeWillyKeeler_at_nowhere.com writes:
> I am trying to load data into a table using SQL*loader in 8.0.3, and am
> getting a "bad" file full of data. The "log" file say that the {whatever} is
> too big. Look:

  I had the same problem. The problem is that SQL*Loader does not understand   the VARCHAR2 datatype, and must be told what the size is:

  Define REFERER in your control file with:

    REFERER CHAR(500)   (I wish the various groups at Oracle who write all their stuff would    make them interoperate properly! Is that too much to ask?)

-- 

Dave Brady                    FAS Computer Services
Sr UNIX Sys Admin/Programmer  Harvard University
brady_at_fas.harvard.edu         LL1A Science Center
Phone: (617) 495-1273         1 Oxford Street
FAX:   (617) 495-1210         Cambridge, MA 02138