| Error- invalid number in query [message #326300] |
Wed, 11 June 2008 00:34  |
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  |
Frank
Messages: 7901
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
