Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> strange field length limit 257 in sqlldr

strange field length limit 257 in sqlldr

From: pm <pm_at_katz.cc.univie.ac.at>
Date: 1997/09/24
Message-ID: <60bfmd$1110$1@ftp.univie.ac.at>#1/1

I have a table which contains a column "longfield" of type VARCHAR2(500). When I try to load this table using sqlldr with the following control file:

LOAD DATA
INFILE 'whatever'
REPLACE INTO TABLE test
FIELDS TERMINATED BY ":"
( shortfield, longfield, numericfield )

I get the following error message:

   Record 261: Rejected - Error on table TEST, column LONGFIELD.    Field in data file exceeded maximum specified length

whenever the length of "longfield" exceeds 257. I know how to work around this problem by specifying

( shortfield, longfield char(500), numericfield )

in the control file. Nevertheless, I'd like to know:

(*) Where does the "maximum specified length" come from? I have not

    specified any maximum length except 500. Why does sqlldr not recognize     the maximum length 500 from the table definition?

(*) Why 257, of all numbers? I could understand 256, but 257? Is there

    a way to alter this strange default maximum length?

I am running Oracle 7.3.3 on an IBM RS/6000 with AIX 4.2. Any help will be appreciated.

         Peter

-- 
Peter Marksteiner                       e-mail: Peter.Marksteiner_at_univie.ac.at
Vienna University Computer Center                   Tel: (+43 1) 4277 14055
Universitaetsstrasse 7, A-1010 Vienna, Austria      FAX: (+43 1) 4277 9140
Received on Wed Sep 24 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US