SQL*Loader

[Quoted] I have problem with on INFILE clause on my control file. My control file :
LOAD DATA
INFILE 'donnees.d' "str X'7c0d0a'"
INTO TABLE sfwnfact
FIELDS TERMINATED BY '|'
(

...
)

I am on NT system. All my record of my data file finished by '|CRLF' string
( in hex 7c0d0a ) i control

it with hex editor but some lines have 0d0a.

But when i run SQL*LOADER i have one line (the first line of my file not the
first record because
i have 0d0a in the middle of my record) to load on my database.

What's happen ?

Thank's for all

--
[Quoted] Yann PICHOT			ypichot_at_sigma.fr
SIGMA Informatique		poste : 1690
La Gesvrine - 3 rue Newton - BP 4127
44241 La Chapelle Sur Erdre - FRANCE
Tel	: +33 02 40 37 66 20	Site web :  http://www.sigma.fr
Fax  : +33 02 51 12 79 52


Sent via Deja.com
http://www.deja.com/