Re: HELP - decimal place problem!

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news: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).

Thanks. I think that definitely had something to do with it. However, I was getting buffer overruns in TOAD. I took out the DBMS_OUTPUT.PUTLINE stuff and it works fine. hmmm??

>
> Daniel Morgan
>
Received on Wed Jun 19 2002 - 00:09:24 CEST