Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01722: invalid number
Use for ex:
ALTER TABLE <table_name> MODIFY ( <column_name> NUMBER(32,5));
Pozdrowienia :-)
Dariusz Ludwiczak wrote:
>
> 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.
Received on Tue Aug 31 1999 - 04:51:35 CDT