I am loding some data from an external file to Oracle Table using Oracle SQL Loader concurrent program in Oracle EBS. I wrote a control file and everything works fine except for one record which goes to next line. I gave an example of one sample good record and the record which is failing
"42814160014","DAILY AWARE INC",.0000,2017-08-02 08:43:05,33960 --good record
"5482984000848129","TRAVEL MART -- record failing load becuase of the line feed or CR.
CORPORATION LLC",.0000,2018-10-16 10:24:36,34982
I used a replace function to remove Chr(10) and chr(13) with white space so that the line feed will go away. But it does not work .
Can someone suggest best solution in the control file to handle this. the 2nd and 3rd line should together read as one record
Please help
George