Re: ORA-01722: invalid number

Which statement is causing trouble on which table?

Martin

Dariusz Ludwiczak wrote:
>
> 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 Sun Sep 05 1999 - 00:00:00 CDT