ORA-12899: value too large for column

ORA-12899: value too large for column

Oracle PL/SQL error message: ORA-12899: value too large for column.

Cause:

You tried to do an insert or an update column with a value too large for column.

Solution:

Enter a value smaller than the column width or expand the column width./p>

Example:

CREATE TABLE TEST(
	TEST_ID NUMBER NOT NULL ENABLE, 
	TEST_NAME VARCHAR2(5) NOT NULL ENABLE
);

INSERT INTO TEST (TEST_ID, TEST_NAME) VALUES (1, 'ABC123456');

table TEST created.

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

Correct insert:

INSERT INTO TEST (TEST_ID, TEST_NAME) VALUES (1, ‘ABC12’);