Re: NLS_PARAMETERS in 8?

You need to set those as keys in the registry under HKLM\software\oracle. This is a client side problem.

Hth,

--
Sybrand Bakker, Oracle DBA
Göran K <goranNOgoSPAM_at_champion.se.invalid> wrote in message news:0a0133f8.8d7f3beb_at_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?
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon Nov 15 1999 - 13:15:32 CST