Achim Moehler <achim.moehler_at_freenet.de> wrote in message news:<3B9931EF.E69478CA_at_freenet.de>...
> 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
In Peru, we use "." like decimal delimiter and "," like group delimiter
Example: US$ 1,235.55
Received on Fri Sep 07 2001 - 21:55:15 CDT
