Problems of data wrap when loading with sql loader
I am using sql loader to load data in flat file in HP UNIX.
I find the if the data of NUMBER type or date type get wraped to the new line, the control file raised the errors.
The data looks like(Field dilimiter is | , record dilimter is ~):
1-A87CCH|1-A87CCH|PLAN_ACCOUNT_PROMOTION|1-HIR6A|20100706 06:06:24|1-DNE1|DC ??
2010.7 Promoiton FY1011|1-A87AW0||1-HJEZE||Private|20100730 00:00:00|20100710 00
:00:00|0|Completed|||||20100730 00:00:00|20100710 00:00:00|0|1-4A6PKP|TFMAAI|||N
|0|0|0|0|0|0|1-4A6PKP|Approved||||||||||||||||1-8U4E-163||20110630 00:00:00|||||
20100708 01:45:35|20100707 00:00:00||-1|||0|9000|0|0||||||100||||||||||N|0|0|0|0
|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|N|20110426 04:01:34|||1-8U4E-163|||0|||||||||
|||||~
The control file looks like:
OPTIONS (ERRORS=1000,DIRECT=TRUE,PARALLEL =TRUE,DATE_CACHE=5000,discardmax =