Re: ORA-01722

forlist2001_at_yahoo.com (kumu) wrote in message news:<a44abd39.0204021306.608e03b2_at_posting.google.com>...
> I have a Sun Solaris machine with Oracle 8.1.7.2 database and I am
> accessing it from the windows NT workstation French version. The
> application I am using is unable to populate the numeric fields in
> Oracle its generating ORA-01722 Error. The same application works fine
> in other scenario Do you have any suggestion what might be potential
> problem.
>
> Thanks a lot
> Kumu

I bet your application puts character data into numeric fields. Oracle can handle it if it can convert them into numbers. If not (they are null, for example), you get 1722. Received on Thu Apr 04 2002 - 06:50:34 CEST