Re: ora-1722 error (help a newbie this morning)

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 8 Sep 1999 17:49:44 +0200
Message-ID: <7r60k3$k3g$1@oceanite.cybercable.fr>

A way to investigate:
select value from v$nls_parameters where parameter='NLS_NUMERIC_CHARACTERS'; the first character gives you the character for the decimal point. For example,
v805>select value from v$nls_parameters where parameter='NLS_NUMERIC_CHARACTERS';

VALUE

---

.,

1 row selected.

v805>select to_number('1.25') from dual;

TO_NUMBER('1.25')

---

             1.25

1 row selected.

v805>select to_number('1,25') from dual; select to_number('1,25') from dual

                 *

ERROR at line 1:
ORA-01722: invalid number

v805>alter session set nls_numeric_characters=',.';

Session altered.

v805>select to_number('1.25') from dual; select to_number('1.25') from dual

                 *

ERROR at line 1:
ORA-01722: invalid number

v805>select to_number('1,25') from dual;

TO_NUMBER('1,25')

---

             1,25

1 row selected.

v$nls_parameters and nls_session_parameters gives you the current value of the parameter for your session. nls_database_parameters gives you the permanent value for the base. nls_instance_parameters gives you the value for the instance (see init.ora and v$parameter).

Audun Tornquist a écrit dans le message ...
>Just a clarification:
>it works when the string contains an integer number but not when there's a
>decimal point... anyone have any ideas?
>
>regards,
>/.a.
>
>
>
>Audun Tornquist <audun_at_iname.com> wrote in message
>news:SWrB3.957$6O2.9104_at_news1.online.no...
>> We updated from Oracle v7.3 to 8 and I'm now getting this error when
>trying
>> to update the database from my c++ code (ora-1722: Invalid
>number)...doesn't
>> v8 accept conversion between a string and a number the same way v7.3 did
>> (the datamember is a cstring in my program and a number in the dbase)?
>>
>> regards,
>> /.a.
>>
>>
>
>
Received on Wed Sep 08 1999 - 10:49:44 CDT