Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> NLS_PARAMETERS in 8?

NLS_PARAMETERS in 8?

From: Göran K <goranNOgoSPAM_at_champion.se.invalid>
Date: Mon, 15 Nov 1999 03:15:53 -0800
Message-ID: <0a0133f8.8d7f3beb@usw-ex0102-009.remarq.com>


Hi

I have just migrated a database from 7.3.3 to 8.0.5 It's running on NT4 w SP4.

I am loading data with SQLLDR.
In the data there are Price-columns, that is values with decimals. The data comes with ',' as decimalseparator.

In 7.3.3 it worked fine, now in the 8.0.5 sqlldr80 protests about the price-column. I've tried to set: NLS_TERRITORY = SWEDEN (and also: NLS_ISO_CURRENCY = SWEDEN)
in the initDB.ora-file.

But it still doesn't work, and if i select * from v$nls_parameters I still have AMERICA and AMERICAN everywhere! What should I do?

Received on Mon Nov 15 1999 - 05:15:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US