Re: Oracle sqlldr text field limit?

In article <3C2CDE2F.F29A4B11_at_njcc.com>, james says...
>
>I've installed Personal Oracle8i on my PC under Windows 98 SE (lots of
>disk, lots of memory) and it seems to be working just fine. But I've hit
>a 'problem' with the loader (SQLLDR) that I can't find described. I
>have a simple text file with many records -- first few columns numeric
>followed by a separator character ($) followed by text -- from a few up
>to 1000 or more before the end of records.
>
>When I run sqlldr to put this data into a simple table TEST defined
>with two columns (A number(10), B varchar2(1500)), where the sqlldr
>control file (guts) looks like: append into table TEST fields
>terminated by '$' (A,B) --
>

append
into table test
field
( a,
  b char(1500)
)

the default type used by sqlldr is char(255), if the data in the file exceeds 255 bytes, you need to give it a clue as to the max width it is expecting.

>the loader rejects all input lines where the second field is longer than
>255 characters (otherwise works O.K. on the other records).
>
>Is this a limit to sqlldr or have I overlooked something. (I can
>populate the table TEST with long B columns manually from within
>SQLPLUS).
>
>Thanks in advance for any help, jim goodman jgoodman_at_njcc.com
>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp