Re: sql*loader and long

   Use the 'CONTINUEIF' clause! It's designed to handle exactly what you're trying to do. And it's documented too, in the utilities guide.

   Joong

Deborah Jorge (jorge_at_openmarket.com) wrote:
: I have a table that has one column declared to be long.
 

: The long data which spans multiple lines, is being truncated
: when inserted into the table using SQL*Loader.
: SQL*Loader thinks that each newline is a new record. Silly thing.
 

: SunOS 5.5.1 sparc SUNW, Ultra-2
: Oracle 7.3.2
 

: I cannot use Reclen since it is obsolete and has no effect.
: I've tried specifying "RECSIZE ##" in the control
: file, but I get SQL*Loader-500 Unable to open file (/blah)
: when using this.
: I've tried specifying char(3000) after the column name in the
: control file, but this does not work either.
 

: I've tried various delimiters, and even positional data.
: The newlines must be preserved in the data.
 

: Unfortunately, I have not come across the correct combination.
 

: What has been successful for you?
 

: Thanks in advance,
: Debi Jorge jorge_at_openmarket.com
: Open Market, Inc. http://www.openmarket.com/
: 245 First Street
: Cambridge, MA 02142 (617) 252-3484 Fax: (617) 621-1703
Received on Tue Sep 03 1996 - 00:00:00 CEST