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.
