ORA-01438 value larger than specified precision allowed for this column when inserting 3

Question

I m running into that error when trying to insert any number except 0 into a field with format NUMBER  2 2    UPDATE     PROG OWN PROG TPORCENTAJE MERMA SET     PCT MERMA   3 WHERE     IDN PORCENTAJE MERMA   1    Error Code  1438  SQL State  22003   ORA-01438  value larger than specified precision allowed for this column  COLUMN NAME DATA TYPE   TYPE NAME   COLUMN SIZE   BUFFER LENGTH   DECIMAL DIGITS PCT MERMA   3           NUMBER      2             0               2   It also happens if I try with decimal numbers    Any idea why

User · Accepted Answer

You can t update with a number greater than 1 for datatype number 2 2  is because  the first parameter is the total number of digits in the number and the second one   i e 2 here  is the number of digits in decimal part  I guess you can insert or update data  lt  1  i e  0 12  0 95 etc   Please check NUMBER DATATYPE in NUMBER Datatype

User · Answer

NUMBER  precision  scale  means precision number of total digits  of which scale digits are right of the decimal point   NUMBER 2 2  in other words means a number with 2 digits  both of which are decimals  You may mean to use NUMBER 4 2  to get 4 digits  of which 2 are decimals  Currently you can just insert values with a zero integer part   More info at the Oracle docs

[sql] "ORA-01438: value larger than specified precision allowed for this column" when inserting 3

Examples related to sql

Examples related to oracle