Re: ORA-01722

I checked the SQL query fired by the application and it has 4.5000 in the sql insert statement. Only thing I am not to sure about is because it is a mixed environment is OS changing/ interpreting Query differently...
:)

afilonov_at_yahoo.com (Alex Filonov) wrote in message news:<336da121.0204032050.6ad8b531_at_posting.google.com>...
> 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 Fri Apr 05 2002 - 18:16:56 CEST