Re: Numeric Format

Are you shure, you use the right delimiter? What happens when you do this:

SQLWKS> select to_number('0,125') + to_number('0,538') from dual

Achim Möhler

Ricardo Suyon schrieb:
>
> Hi.
>
> I have an Oracle Server 7.3.4.
> When i run this script i get this result:
>
> SQLWKS> select to_number('0.125') + to_number('0.538') from dual
> 2>
> TO_NUMBER(
> ----------
> .663
> 1 row selected.
>
> I made an export from this database to a Oracle Server 8.0.4.When I
> execute the same script, I get this error message:
>
> SQLWKS> select to_number('0.125') + to_number('0.538') from dual
> 2>
> TO_NUMBER(
> ----------
> ORA-01722: invalid number
>
> All the numeric data has another numeric format:
>
> 7.3.4 8.0.4
> ======== =======
> 10235.88 1023588
> 56986.95 5698695
> 96535.45 9653545
> 12354.96 1235496
> 65842.18 6584218
> ...
>
> At parameters in both servers
>
> nls_currency
> nls_date_format
> nls_iso_currency
> nls_language AMERICAN
> nls_numeric_characters
> nls_sort
> nls_territory
>
> After I try with a full database export/import and the error remains.
>
> Can you tell me where is the error.
>
> Thanks in advance.
>
> Ricardo Suyon
Received on Fri Sep 07 2001 - 15:45:35 CDT