SQL*Loader question

From: p <Philp_at_envision-ts.com>
Date: Mon, 20 Dec 1999 12:09:46 -0700
Message-ID: <385E7EF9.AE89254F@envision-ts.com>

SQL*Loader is rejecting records that have a return character in a varchar(254) column 'blah_char' imbedded in the data.

Sample table:

SQL> desc blah

Name                                            Null?

Type

----------------------------------- --------------- --------------------

blah_key                                        NOT NULL    NUMBER(38)

blah_char
VARCHAR2(254) My control file looks like:

load data
infile 'somefile.dat'
insert into table blah
fields terminated by "," optionally enclosed by '"' trailing nullcols
(
blah_key,blah_desc
)

The somefile.dat sample data.

1,"some data"
2,"this data is
rejected"
3,"more data"

Record 2 gets rejected as SQL*Loader hits apparent end of line even though I instruct SQL*Loader that field terminated by '"'.

How do I get around this problem with free format infile?

Thanks in advance,

Phil Received on Mon Dec 20 1999 - 13:09:46 CST