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
yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa
Member
I am getting the error -ORA-01722 while trying to execute the statements as follows :
1)SUM(TO_NUMBER(SOI_QTY||'.'||SOI_QTY_LS) - (SOI_INVI_QTY_BU/IU_CONV_FACTOR/IU_MAX_LOOSE_1)) PNDG_QTY,

2)AND TO_NUMBER(SOI_QTY||'.'||SOI_QTY_LS) > (SOI_INVI_QTY_BU/IU_CONV_FACTOR/IU_MAX_LOOSE_1)

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

Yogesh
Re: Error- invalid number in query [message #326302 is a reply to message #326300] Wed, 11 June 2008 00:44 Go to previous message
Frank
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 Dec 10 03:04:44 CST 2016

Total time taken to generate the page: 0.09347 seconds