Re: ORA-01722 - Invalid number

Hi,

See what is your decimal point in both your Windows client and your Oracle server. Almost for sure they are different. I could just bet that in one you have "." and in another you have ",". They must match of course.

Hope this helps,

Joao Prates

Daniel Cukier <danicuki_at_linux.ime.usp.br> wrote in message news:7p9dc6$mq4$1_at_news.mandic.com.br...
> Hello!
>
> When I use Oracle ODBC driver with my application in Oracle, a get this
> error (ORA-01722 - invalid number) when using number fields (only those
with
> decimals)
>
> I was using Intersolv driver, but I had other problems using it, so now I
> trying to use driver from Oracle Corp.
>
> Does anyone knows something about this error?
>
>
>
> --
> -----------------------------------------------
> Daniel Cukier
> danicuki_at_linux.ime.usp.br
> UIN: 5570114
> -----------------------------------------------
>
>