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 -> Re: ORA-01722: invalid number

Re: ORA-01722: invalid number

From: Doktor <doktor_at_post.pl>
Date: Tue, 31 Aug 1999 11:51:35 +0200
Message-ID: <37CBA5A7.FC61CCF1@post.pl>


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

Original text of this message

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