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 )
One comment
Pingback: Blackboard Learn + Ora-01407 - BlackboardHub.Com