Sql Loader and dates.

From: Ludovic MARLATS <marlats_at_integral-solutions.fr>
Date: Thu, 22 Jul 1999 09:44:21 +0200
Message-ID: <3796CBD4.C78531AE@integral-solutions.fr>

I have to load files into tables. This files are text files and includes date fields.
In text files date appears like this :

    16-04-1997 00:00

In the control file (CTL), there is :

    VEIDTTARGA                DATE(16) "jj-mm-aaaa hh:mm" nullif

VEIDTTARGA=blanks

But when I start SQLLDR, log file includes the following Error :

    Record 1: Rejected - Error on table [name table], column VEIDTTARGA.

    ORA-01810: format code appears twice ...

What's wrong with my date format ?

Thanks.

--

Ludovic MARLATS
marlats_at_integral-solutions.fr

---

Integral Solutions
Parc Cadéra
33700 MERIGNAC Received on Thu Jul 22 1999 - 02:44:21 CDT