ORA-01407: cannot update (string) to NULL

I got ” ORA-01407: cannot update (string) to NULL ”  error in Oracle database.

 

ORA-01407: cannot update (string) to NULL

 

Details of error are as follows.

ORA-01407 cannot update (string) to NULL

Cause: An attempt was made to update a table column "USER"."TABLE"."COLUMN" with a NULL value.

Action: Retry the operation with a value other than NULL.

 

 

cannot update (string) to NULL

This ORA-01407 errors are related with the attempt was made to update a table column “USER”.”TABLE”.”COLUMN” with a NULL value.

To solve this error, Retry the operation with a value other than NULL.

Or you can drop the NOT NULL constraint on the related table.

 

For example, you have created the following table.

CREATE TABLE employee
( id number not null,
name varchar2(50) not null 
);

 

You can not update the name or id column with the NULL value, because you will get this error.

UPDATE employee  SET name = null WHERE id = 1453;

 

You can update it with any value as follows.

UPDATE employee  SET name = 'MEHMET' WHERE id = 1453;

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

See more