Problems with SQL*LOADER and numbers

Hi,

[Quoted] I use SQL*LOADER to fill in the following table (the name of which is "jerome") :

    Nom                  Non renseigné NULL? Type
    ------------------------------- -------- ----
    ISO_NUM                                  NUMBER(3)


    (...)

    DERNIER_COURS_VENTE_CONNU                NUMBER(3,9)

The data file contains :

    "504","MAD","204","DIRHAM MAROCAIN","0","3.1"     "280","DEM","4","DEUTSCHE MARK RF","0","3.299864677"
(...)

The control file looks like :

    LOAD DATA
    INFILE 'C:\TEMP\COURS\COURS.ASC'
    REPLACE
    INTO TABLE VL.JEROME
    FIELDS TERMINATED ',' OPTIONALLY ENCLOSED '"'     (

         ISO_NUM,
        (...)
         DERNIER_COURS_VENTE_CONNU

When I launch SQL*LOADER, it answers (log file) :

    Enregistrement 1 : Rejeté - Erreur sur table EMP, colonne SAL.     ORA-01722: Nombre invalide

    Enregistrement 2 : Rejeté - Erreur sur table EMP, colonne SAL.     ORA-01722: Nombre invalide

(...)

(in english : "Record 1 : Rejected - Error into table EMP, row SAL. ORA-01722: Invalid number")

SQL*LOADER seems not to understand floating numbers like 3.299864677. I have tryed 3,299864677 ("," or "." as separator) but it don't recognize the number.

What can I do ?

thank you a lot
jerome

--
poirier_at_gla.ecoledoc.lip6.fr
http://gla.ecoledoc.lip6.fr/~poirier