Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL LDR and FLOAT field
<grille11_at_yahoo.com> wrote in message
news:c3c3j8$28c$1_at_reader1.imaginet.fr...
> Hi,
>
> I am desperatly trying to load a simple csv file into an empty table (may
be
> not that simple after all!).
> 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?
> (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
>
>
Hi,
This works fine in Oracle 9.2.0.1 on WinXP Pro. All nine (9) records are
loaded.
SQL> select * from stock_data;
CODE NBTYPE YEAR PE IS VALUE ---------- ---------- ---------- -- -- ----------
SIEGn.DE DBFI058 1989 A N 10684.1027 SIEGn.DE DBGE001 1989 A N 370000 SIEGn.DE DBGE002 1989 A N 365000 SIEGn.DE DBIA001 1989 A N 18693.8026 SIEGn.DE DBIA002 1989 A N 11586.3853 SIEGn.DE DBIA003 1989 A N 6335.3 SIEGn.DE DBIA004 1989 A N 2797.5 SIEGn.DE DBIA005 1989 A N 4768.4 SIEGn.DE DBIA008 1989 A N 7107.41731
9 rows selected.
Could you be more specific as to the version of Oracle you are using and on which operating system? What are the exact error messages that you get?
Douglas Hawthorne Received on Thu Mar 18 2004 - 06:53:32 CST