Home » SQL & PL/SQL » SQL & PL/SQL » Error- invalid number in query (Oracle 10, Toad 9.5)
Error- invalid number in query [message #326300] Wed, 11 June 2008 00:34 Go to next message
Messages: 50
Registered: October 2007
Location: Silvassa
I am getting the error -ORA-01722 while trying to execute the statements as follows :


What changes are required to execute the above statements sucessfully..

Re: Error- invalid number in query [message #326302 is a reply to message #326300] Wed, 11 June 2008 00:44 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
What is the datatype of SOI_INVI_QTY_BU, IU_CONV_FACTOR and IU_MAX_LOOSE_1?
Are you sure SOI_QTY and SOI_QTY_LS only contain integers? (by the way, this is a lousy design)

Is '.' your decimal separator?

Execute the calculation in parts, adding more and more. That way you will be able to see where it goes wrong.
Previous Topic: sql query not working
Next Topic: What is the differences between views and synonyms?
Goto Forum:

Current Time: Sat Jul 22 21:57:56 CDT 2017

Total time taken to generate the page: 0.09973 seconds