Tag Archives: ORA-01407

ORA-01407: cannot update (string) to NULL

oracle

ORA-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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/