SQL LDR and FLOAT field

From: <grille11_at_yahoo.com>
Date: Thu, 18 Mar 2004 13:28:19 +0100
Message-ID: <c3c3j8$28c$1_at_reader1.imaginet.fr>



Hi,

[Quoted] [Quoted] I am desperatly trying to load a simple csv file into an empty table (may be not that simple after all!).
[Quoted] It keeps on telling the numbers are invalid for the colun value. When I get rid of the digits after the comma it works fine. Would there be a way to load big numbers with sqlldr?
[Quoted] (It also does not work with the datatype NUMBER, same message).
Thanks for helping.

here is my ctl file

LOAD DATA
INFILE 'C:\loadCSV\testrun.csv'
INTO TABLE STOCK_DATA
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(CODE, NBTYPE, YEAR, PERIOD, IS_ESTIMATE, VALUE )
The structure of my table:

CREATE TABLE OWNER.STOCK_DATA
(

    CODE        VARCHAR2(10) NOT NULL,
    NBTYPE      VARCHAR2(10) NOT NULL,
    YEAR        NUMBER(10)   NOT NULL,
    PERIOD      VARCHAR2(2)  NOT NULL,
    IS_ESTIMATE VARCHAR2(2)  NOT NULL,
    VALUE       FLOAT(126)   NOT NULL

)

Here is what looks like my csv file:

SIEGn.DE,DBFI058,1989,A,N,10684.102654
SIEGn.DE,DBGE001,1989,A,N,370000.000000
SIEGn.DE,DBGE002,1989,A,N,365000.000000
SIEGn.DE,DBIA001,1989,A,N,18693.802631
SIEGn.DE,DBIA002,1989,A,N,11586.385320
SIEGn.DE,DBIA003,1989,A,N,6335.300000
SIEGn.DE,DBIA004,1989,A,N,2797.500000
SIEGn.DE,DBIA005,1989,A,N,4768.400000
SIEGn.DE,DBIA008,1989,A,N,7107.417311
Received on Thu Mar 18 2004 - 13:28:19 CET

Original text of this message