Monday, February 4, 2019

ORA-12899: value too large for column | Karan Rajpoot

                                              ORA-12899: value too large for column


Error: - ORA-12899: value too large for column.



Cause: - This error occurs when you have given the data type value which is greater than its maximum value.



Solution: - Try to give the data type value under its maximum assign value or try to increase the size of the maximum value.


let's understand the things with the help of the below example: -


Example: -


Step 1)

SQL> create table employee (emp_id number, emp_name varchar(10), emp_desig varchar(10));


Table created.


Step 2)

SQL> insert into employee values (1001, 'Paul', 'Project_Engineer');
insert into employee values (1001, 'Paul', 'Project_Engineer')
                                           *
ERROR at line 1:
ORA-12899: value too large for column "SYS"."EMPLOYEE"."EMP_DESIG" (actual: 16,
maximum: 10)

Note: - At the time of table creation the data type value of the emp_desig has given as 10 but the value of  emp_design which has been inserted it was greater than its data type value, this is the cause that error has occurred.

Hope that will resolve your issue.