Re: sqlldr load numbers changing decimal

On Thu, 18 Nov 2004 16:47:31 +0100, <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
>

If I'm not mistaken this behaviour is controlled by the TERRITORY part of NLS_LANG. If it does not disturb anything else, you could set NLS_LANG for instance to AMERICAN_AMERICA.<same characterset> just for this load.

Jaap. Received on Thu Nov 18 2004 - 14:58:14 CST