Hi,
We are using SQL Loader to load text files in the Oracle Tables.
We have a table Invoice_Serial where we have a field Serial_Number which of long datatype.
We are issuing the below command

sqlldr scott/tiger CONTROL=INVSERNO.CTL, LOG=INVSERNO.LOG, SILENT=HEADER,FEEDBACK, BINDSIZE=130000,ERRORS=10000

We get the following error in the log file

Record 3: Rejected - Error on table INVOICE_SERIAL, column SERIAL_NUMBER.
Field in data file exceeds maximum length

We found that sql loader takes only those columns where the field length is limited to 255

We have even tried changing the datatype to varchar2(4000). But the same problem persists

Pl help, its urgent.

Thanks in Advance.