Re: Q:SQL*Loader Problem with Date ORA-01861-solved

Hi,
after MANY hours i solved my problem!
Oracle gives me a ORA-01861 Error, but that wasn't the problem. I got two bugs in my controlfile. The major bug was 'TERMINATED BY WHITESPACES' for the integer externals! After delete this I run in the next problem. The CSV File was generated by a AS400 and before CRLF it writes a Hex '00'.

Of course i learned a lot with nls_date_format :-)

If someone is interested i can post my new controlfile.

THANKS to ALL who help me!!!
ralf

>>>>>>>>>>>>>>>>>> Ursprüngliche Nachricht <<<<<<<<<<<<<<<<<<

Am 30.10.2002, 09:51:57, schrieb Ralf Bender <ralf.bender_at_arcor.de> zum Thema Q:SQL*Loader Problem with Date ORA-01861:

> Hi,

> i want to fill in my Table R8 with CSV Data. The file looks like this:
> "38F ","38F
> ","A",911 ,5001 ,"01","001","6183090","2000-03-10","0010610 "
> "390 ","390
> ","A",912 ,5001 ,"01","001","6183100","2000-03-10","0010610 "
> "391 ","391
> ","A",913 ,5001 ,"01","001","6183360","2000-03-10","0010620 "

> My Problem is the date. I always get a ORA-01861 Error. Here is my
> Controlfile:
> LOAD DATA
> INFILE 'R8'
> into table R8
> fields terminated by "," optionally enclosed by '"'
> (
> notesdocid,
> gpfearcid,
> arclevel,
> decdocid INTEGER EXTERNAL TERMINATED BY WHITESPACE,
> doctype INTEGER EXTERNAL TERMINATED BY WHITESPACE,
> ablagekreis,
> mandant,
> rechnr,
> dokdatum "to_date(:DOKDATUM,'YYYY-MM-DD')",
> kundennr
> )

> What's wrong with dokdatum?
> Can Someone help me?

> Thx
> Ralf
Received on Mon Nov 04 2002 - 14:15:26 CST