Database Utilities (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center