Re: SQL*Loader question

On Mon, 20 Dec 1999 12:09:46 -0700, p <Philp_at_envision-ts.com> wrote:

>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
>

SQL*Loader doesn't support most control characters (even after years of us poor users complaining). The only way we've tackled this is to replace you cr's with another string, and once loaded, use the replace function to set them back.

Ciao
Fuzzy
:-) Received on Mon Dec 20 1999 - 00:00:00 CST