Re: ORA-12708

From: Jurij Modic <jmodic_at_src.si>
Date: Sat, 30 Jan 1999 09:43:33 GMT
Message-ID: <36b2d437.8102779@news.arnes.si>

On Fri, 29 Jan 1999 19:29:17 +0400, Andy <andy_at_mark-bell.udm.ru> wrote:

>Help please!
>I set NLS_NUMERIC_CHARACTERS as '.'
>and if I start Oracle see this error:
>ORA-12708: error while loading create database NLS parameter
>NLS_NUMERIC_CHARACTERS.
>
>What can I do? Oracle 8.0.5 + Linux.

You must provide *two* characters for the NLS_NUMERIC_CHARACTERS parameter, enclosed by double quotes, eg NLS_NUMERIC_CHARACTERS=". ".

The first of two characters will be used as decimal separator and a second one as a group separator (for separating thousands, millions etc). So for the above example the "." is used as a decimal point and a blank (" ") as a group separator.

>Thanx for all help!
>
>Andy.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Sat Jan 30 1999 - 03:43:33 CST