| Line break problem in sql loader [message #254206] |
Thu, 26 July 2007 02:52  |
adun50
Messages: 1
Registered: July 2007
|
Junior Member |
|
|
Hi people,
I'm inserting data into a table through sql loader using a csv file. The problem I'm having is when it comes to a field where the data has a line break, it'll insert it into a new row, or place the record into the bad file, but truncated.
eg
fields:
messageid, message, messagetype
data:
1, "Hello World", "text"
2, "This is a
message", "text"
3, "A message", "text"
In the bad file, it shows that the second one failed and appears as:
2, "This is a
Is there a way to fix this from happening without the need to change the csv files?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
