Re: ORA-01722

forlist2001_at_yahoo.com (kumu) wrote in message news:<a44abd39.0204050816.3a553613_at_posting.google.com>...
> 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...

Could you post the text of the insert statement here? If it's one insert only, you can find out what actual statement was executed by Oracle using trace. Put "alter session set sql_trace=true" statement before insert in your application. Find the trace file in user_dump_dest directory, it's the newest file over there. Then run tkprof on this file:
tkprof <file-name> <output-file-name> explain=<username/password>

> :)
>
> 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 Sat Apr 06 2002 - 00:53:59 CEST