From: "fumi" <fumi@tpts5.seed.net.tw>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Sql Loader and Carraige Returns
Date: Tue, 24 Apr 2001 22:11:39 +0800
Organization: SEEDNet News Service
Lines: 14
Message-ID: <9c44n8$r97$1@news.seed.net.tw>
References: <3ADEF298.1F6CBA5D@wbbx.com>
NNTP-Posting-Host: sj3-72.dialup.seed.net.tw
X-Trace: news.seed.net.tw 988124713 27943 211.74.3.72 (24 Apr 2001 15:05:13 GMT)
X-Complaints-To: abuse@seed.net.tw
NNTP-Posting-Date: Tue, 24 Apr 2001 15:05:13 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200



"rich ford" <ford1@wbbx.com> ????? news:3ADEF298.1F6CBA5D@wbbx.com...
> I am trying to load data using Sql Loader.  A couple of the
> columns are VARCHAR2(4000) and contain carriage returns.
> So Sql Loader is interpreting the Carriage returns as
> End of Record.
>
> Any way around this?


You can use CONTINUEIF keyword in the control file.
Take a look about "logical recods" on Oracle8 Utilities manual.