Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-01722: invalid number

ORA-01722: invalid number

From: Dariusz Ludwiczak <darekl_at_atrix.com.pl>
Date: Tue, 31 Aug 1999 09:39:04 GMT
Message-ID: <37CBA151.DE05119E@atrix.com.pl>


I have a problem with Oracle 8 Client for Win95 ODBC. I’m writing an application in C++Builder which uses databases on an Oracle server through BDE. When I want to add a record to table, which contains integer fields, I obtain an error: [Oracle][ODBC][Ora]ORA-01722: invalid number I discovered that integer fields are treated as floats with a zero values after point (e.g. DECIMAL 32 0) This may cause my problems but I don’t know how to resolve them.
For example Database Desktop from C++Builder 3 have the same problem.

Thank you for any help!

Darek (darekl_at_atrix.com.pl) Received on Tue Aug 31 1999 - 04:39:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US