SQL Loader problems with <CR> in LONG fields
Posted on 2004-11-02
I am using SQL Loader 220.127.116.11.0 to load a text file containing four fields, one of those four being of the LONG datatype. This LONG field is for comments and often contains Carriage Returns. I've read everything I can in here and at ORACLE to try to KEEP those carriage returns in the data, but not allow them to start new records in ORACLE. I've used CONTINUE IF, I've tried fixed length loads and delimited loads. Nothing I seem to do will prevent the load to start a new record in Oracle wherever there is a carriage return.
Here's my basic ctl file using fixed length fields:
(WONUM POSITION (1:10), LDKEY POSITION (11:48), REPORTDATE POSITION (49:67) date "mm/dd/YYYY HH24:MI:SS", LDTEXT POSITION (68:579))