Database Error Messages

OCI-01407

cannot update (string) to NULL

Cause

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

For example, if you enter:

connect scott/tiger update table a (a1 number not null); insert into a values (null);

Oracle returns:

ORA-01407 cannot update ("SCOTT"."A"."A1") to NULL

which means you cannot update the column "SCOTT"."A"."A1" to NULL.


Action

Retry the operation with a value other than NULL.