Re: SQL*Loader Question - please

I've identified the problem. It was the NLS_LANG setting for the database. The table column was expecting a "," and not a decimal. I changed the NLS setting and the data loaded as expected. Thanks for your reply.
Andre

"FC" <flavio_at_tin.it> wrote in message news:bbkCa.25139$pR3.501649_at_news1.tin.it...
>
> Below you can find a couple of control files loading the data in the
> required format.
> The former is using field separators, just in case you want to try another
> method, while the latter uses fixed positions. You can see also that
DECIMAL
> EXTERNAL or FLOAT EXTERNAL do not affect the loaded values in any way.
> Both control files work as expected either with direct path or
conventional
> path, are you sure you're specifying the right POSITIONs?
>
> Bye,
> Flavio
>
>
> create table test_dec (num1 number(14,2), num2 number(14,2));
>
> ---- version 1
>
> load data
>
> infile *
>
> into table test_dec
>
> truncate
>
> FIELDS TERMINATED BY ','
>
> (num1 DECIMAL EXTERNAL,
>
> num2 FLOAT EXTERNAL
>
> )
>
> BEGINDATA
>
> +000000000376.04, -000000000154.70
>
> -000000000376.03, +000000000154.71
>
>
>
> --- version 2
>
> load data
>
> infile *
>
> into table test_dec
>
> truncate
>
> (num1 POSITION(1:16) DECIMAL EXTERNAL,
>
> num2 POSITION(17:32) FLOAT EXTERNAL
>
> )
>
> BEGINDATA
>
> +000000000376.04-000000000154.70
>
> -000000000376.03+000000000154.71
>
>
>
Received on Tue Jun 03 2003 - 05:08:38 CEST