0

So i have created a test table having a number column which is of the data type Number(11,8). Now when i am trying to insert the value 13332 in the table it is throwing an oracle error saying:

ORA-01438: value larger than specified precision allowed for this column

I am not sure why. The same works when i am inserting into a column with data type Number(12,6)

INSERT INTO MY_TABLE(COLUMN_1)
values('13332');
Shubham Sharan
  • 23
  • 2
  • 7

1 Answers1

3

The reason is - out of 11 digits you have specified 8 digits after decimal places so for the whole number part (before the decimal) you are allowed only 3 digits.

Assuming you want to reserve 8 digits post decimal place in your case it would work if you define the data type as number(13,5) which would allow 5 digits for the whole number.

Somy
  • 1,474
  • 1
  • 4
  • 13