SQL*Loader is treating new line character as new record data in .csv file
Hi Team,
I have a requirement to upload the "," separated .csv file which has a column spans across multiple lines (with a newline chars). While uploading through SQL*Loader, I am getting error as shown below
1) Second enclosure string not present
2) ORA-01722: invalid number
E.g.
-----------------------
Record1:
A, B, "ABC", "123"
Record2:
X, Y, "XY
Z", "321"
Record 3:
P, Q, "P
QR", "567"
-----------------------
Please note that record 2nd and 3rd has newline character (it is not a word wrap).SQL loader is treating each line as a new record and hence throwing the error.
Any help would be much appreciated.
Thanks,