I have written a proc that has the following variables declared: nConversionValue NUMBER(10, 6) nQty NUMBER(10, 6) I need the 6 decimal places because the conversion value could be .000002. nQty := nOrderQty/nConversionValue When I originally wrote it, I had 2 decimal places (NUMBER(10,2)) and it worked fine. Now I get the error messages saying: "numeric or value error: number precision too large" Any suggestions? Thanks! Received on Tue Jun 18 2002 - 20:50:03 CEST
I need the 6 decimal places because the conversion value could be .000002.
nQty := nOrderQty/nConversionValue When I originally wrote it, I had 2 decimal places (NUMBER(10,2)) and it worked fine. Now I get the error messages saying: "numeric or value error: number precision too large"
When I originally wrote it, I had 2 decimal places (NUMBER(10,2)) and it worked fine. Now I get the error messages saying: "numeric or value error: number precision too large"
Any suggestions? Thanks! Received on Tue Jun 18 2002 - 20:50:03 CEST
Original text of this message