Skip to content

title: ERR-21069 Invalid data type length : XXX hide: - navigation


ERR-21069 Invalid data type length : XXX#

Version#

7.1.0 or later

Explanation#

Unable to execute the INSERT or UPDATE statement.

Cause#

This error occurs when the length of the value to be inserted or updated exceeds the size of the column. The column name in the error message (XXX) shows which column was exceeded.

iSQL> CREATE TABLE T1 (C1 CHAR(3), C2 VARCHAR(3));
Create success.
iSQL> INSERT INTO T1 VALUES ('a', 'abcd');
[ERR-21069 : Invalid data type length : C2.]

Action#

Check the length of the value and the size of the column shown in the error message. Then reduce the length of the value or increase the size of the column.

iSQL> ALTER TABLE T1 MODIFY (C2 VARCHAR(10));
Alter success.

Reference#

N/A