Re: ORA-01722: invalid number

This isn't so simple becouse I can't change structure if tables on the server. Other applications use them. I'm looking for solution which will not do this.

Niestety, nie do zrobienia ;-(

Doktor wrote:

> 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 - 05:49:02 CDT