Re: sqlldr load numbers changing decimal

grille11_at_yahoo.com wrote:
> Hello,
>
> I am trying to load a text file with numbers containing a . as a decimal.
> The only problem is only comma , is accepted as a decimal on my server.
>
> 1;0;0;2004-02-27 00:00:00;3;0;N;;2004-02-27 00:00:00;;
> 1;1990;2;2003-01-09 00:00:00;5;0;N;1513.2527515762899;;;
>
> my ctl:
> LOAD DATA
> INFILE 'D:\fnbhistoho.txt'
> INTO TABLE "USER"."FINANCIALNUMBERHISTOHOLLOW"
> FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
>
> (FINANCIAL_NUMBER_SET_ID, FISCAL_YEAR, PERIOD_TYPE_ID, DATE_ORA DATE
> "YYYY-MM-DD HH24:MI:SS", NUMBER_TYPE_ID, IS_WIP, IS_ESTIMATED, NUMBER_VALUE,
> NUMBER_DATE_VALUE DATE "YYYY-MM-DD HH24:MI:SS", NUMBER_STRING_VALUE,
> NUMBER_INT_VALUE )
>
>
> the command line:
> sqlldr user/pass_at_server control=D:\testrun.ctl log=D:\log.txt
>
>
> If anyone could help...
> thanks in advance
>
>

Change the environment variable that controls numeric separators and decimals; it's NLS_NUMERIC_CHARACTERS, which is also changed by changing NLS_CURRENCY

-- 

Regards,
Frank van Bortel