ORA-01407: cannot update to NULL

ORA-01407: cannot update to NULL

Oracle PL/SQL error message: ORA-01407: cannot update to NULL.

Cause:

You try to make an update in a NOT NULL column.

Solution:

Alter table column to nullable or update column with a value.




Example:

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

Insert into TEST (TEST_ID,TEST_NAME) values (1,'abc');
update TEST set TEST_NAME = null where TEST_ID=1;

Output:

1 rows inserted.

ORA-01407: cannot update (TEST.TEST_NAME) to NULL