Re: invalid number

Julian Kooiker wrote:

> 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
> > >
> > >
> >
> >

If you're using a tool like SQL*Plus, you can issue the following statement:

SELECT *
FROM nls_session_parameters;

This will give you a lot of information about the current session's settings, such as the date format, date language, and numeric characters.

SQL> SELECT *
  2 FROM nls_session_parameters
  3 ORDER BY parameter;

PARAMETER                      VALUE
------------------------------ ------------------------------
NLS_CALENDAR                   GREGORIAN
NLS_COMP
NLS_CURRENCY                   $
NLS_DATE_FORMAT                YYYY-MM-DD
NLS_DATE_LANGUAGE              AMERICAN
NLS_DUAL_CURRENCY              $
NLS_ISO_CURRENCY               AMERICA
NLS_LANGUAGE                   AMERICAN
NLS_NUMERIC_CHARACTERS         .,
NLS_SORT                       BINARY
NLS_TERRITORY                  AMERICA
NLS_TIMESTAMP_FORMAT           DD-MON-YY HH.MI.SSXFF AM
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-YY HH.MI.SSXFF AM TZH:T
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZH:TZM

15 rows selected.

You can set this parameter in a number of ways. First, you can do it, from the SQL*Plus prompt:

   ALTER SESSION SET nls_date_format='dd-mm-yyyy'

You can also add the same line to your LOGIN.SQL script to do it automatically. Login.sql
may be found in the \DBS directory.

You also might want to take a look at the messages in this newsgroup's "DAte conversion" message thread. This topic is discussed there, as well.

Henry Received on Sat Dec 01 2001 - 15:48:38 CST