SQL LOADER:carraige return inside field value

I am trying to load data into Oracle using SQL Loader. One field is of datatype varchar(255) and has carraige returns inside it. When I try to load the data it takes the carraige return , line feed as an end of line and tries to continue after that and the operation fails. Is there a way to handle this? As a last option I will write a script to search and replace all such CR and LF with some other character, but I was wondering if this could be tackled in any way other than that. I am bcp ing out the data from Sybase and loading it to Oracle. Basically how can I specify a different row terminator other than CR and LF and load the file using SQL Loader.
LVL 2
jbiswasAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
junfebConnect With a Mentor Commented:
SQL*LOADER in the way it works treats CR as end of row. There isn't an easy way to tell it to not treat CR as end of current row. So I guess you need to start writing that script to get rid of the CR if you want to use sql*loader to load the data.

Thanks.
0
 
jacsCommented:
You can try with this options

* Use RECLEN sentence to set then oy de row.

* Use the CONCATENATE option to set a number of lines inside
a row.

* Use TERMINATED sentence to set the terminator for the fields.
0
All Courses

From novice to tech pro — start learning today.