Re: invalid number

Depend of the client installation language

If you want force this parameter use:

 ALTER SESSION SET NLS_NUMERIC_CHARACTERS = 'dg' ;

where: d is the new decimal character, and g is the new group separator. The decimal character and the group separator must be two different single-byte characters, and cannot be a numeric value or any of the following characters: plus sign ("+"), minus sign or hyphen ("-" ), less-than sign ("<"), or greater-than sign (">").

 If the decimal character is not a period (.), you must use single quotation marks to enclose all number values that appear in expressions in your SQL statements. When not using a period for the decimal point, use the TO_NUMBER function to ensure that a valid number is retrieved.

For more information see Oracle8i National Language Support Guide http://technet.oracle.com/doc/oracle8i_816/server.816/a76966/toc.htm.

"Julian Kooiker" <kooikerj_at_zonnet.nl> ha scritto nel messaggio news:9u2osk$r1h$1_at_reader06.wxs.nl...
> how can I check this parameter? where can I find it?
>
> "francot" <f.turanonoreply_at_meglo.com> wrote in message
> news:9u2nim$3v5$1_at_atlantis.cu.mi.it...
> > Verify the NLS_NUMERIC_CHARACTERS parameter (client side)
> >
> >
> >
> > "Julian Kooiker" <kooikerj_at_zonnet.nl> ha scritto nel messaggio
> > news:9u2j2k$o3s$1_at_reader06.wxs.nl...
> > > I am trying to insert some data into an oracle 8i database.
> > > When i'm using my application (developed with powerbuilder) on my
> computer
> > > it works fine. When I am using the application on other computers it
> works
> > > fine, but when my boss want to use the application on his computer,
the
> > > application says: Invalid number. What can be the problem?
> > >
> > > Julian Kooiker
> > >
> > >
> >
> >
>
>
Received on Wed Nov 28 2001 - 07:48:25 CST