Re: ORA-01722 - Invalid number

I got the same error when using the Oracle driver. My problem was the conversion of commas as decimals with nls numeric formats. I switched to the MS-ODBC driver for oracle which solved my problem.

Ted

On Mon, 16 Aug 1999 13:17:34 -0300, "Daniel Cukier" <danicuki_at_linux.ime.usp.br> wrote:

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

EMail: knijff_at_bigfoot.com Received on Sun Sep 26 1999 - 04:26:32 CDT