Hi,


I've searched on "cr lf Sql loader" but no joy I'm afraid.

The problem relates to special characters (line end/new line or otherwise known as carriage return) appearing on one (or more) records which resulted on a split of a single record into multiple records during load using SQL Loader, and subsequent failure of load.

I'm sure this has been covered a million times so apologies.

I'd appreciate it if you could offer solutions (which I'm sure are simple).