Re: HELP - decimal place problem!
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 18 Jun 2002 20:41:47 GMT
Message-ID: <3D0F9AFB.B9C8B5E2_at_exesolutions.com>
Date: Tue, 18 Jun 2002 20:41:47 GMT
Message-ID: <3D0F9AFB.B9C8B5E2_at_exesolutions.com>
Cynic wrote:
> 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!
My guess ... without seeing the data is that you used to have 8 integers to
the left of the decimal point. Now you only have room for four.
Perhaps try NUMBER(14,2).
Daniel Morgan Received on Tue Jun 18 2002 - 22:41:47 CEST