Hi,

I have a kron job in Linux which generates CSV files, which are to read by SQL Loader to load the data into the database. The Oracle db is in Windows. When I try to read the the control file to execute it, it can not handle the carriage returns and line fees in the file. It terminates on the very first line. Please help on how to resolve this.

This is the SQL script. Is there a change to be made to the script?

Code:
load data
infile 'test.DAT'
INSERT into person
fields terminated by ',' optionally enclosed by '"'
(
FIRST_NAME , 
LAST_NAME , 
DATE_OF_BIRTH , 
SSN , 
AGE , 
SALARY , 
EMPLOYER , 
DEPT
)