Re: Help!!! Urgent Query on size limit of Number type field

Hi,

Don''t know what version of Oracle you use, anyway, what you describe shouldn't be a problem.
Oracle 7 already accepts values with a precision of 38. And in fact, number(18,3) means 18 digits of which 3 decimals, so even 15 integers and three decimals should be possible.
But how do you insert? Isn't the problem maybe in your application? Do you get error messages when values are refused?

regards,

Henk Hultink

--
H. Hultink
Software Engineer
Stoas, Division OBOI
Wageningen, The Netherlands
"Activating Knowledge"
http://www.stoas.nl

e-mail: hhu_at_stopspam.stoas.nl

"Kanv" <kanvpandit_at_hotmail.com> wrote in message
news:2554c5c7.0303240547.4285382b_at_posting.google.com...


> I have a few critical tables containing Number type fields

> [Number(18,3)]. But when an attempt is made to insert a number in the

> format of 14 intergers, one decimal point and 3 decimal values (all

> adding upto 18), it truncates the decimal values refuses to insert the

> amount sometimes. Whats going wrong here? Is there a limit to the

> number of decimals which can be stored? whats the limit for a number

> type field?