How to Solve :
Oracle database error code ORA-01407 – cannot update (string) to NULL
Oracle Database Error Code ORA-1407 Description :
cannot update (string) to NULL
Error 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 NULLwhich means you cannot update the column “SCOTT”.”A”.”A1″ to NULL.
How to Solve :
Retry the operation with a value other than NULL.
Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes Etiketler: ora - 1407, 01407, 1407, about oracle ORA-01407 error, cannot update (string) to NULL, help ORA-01407 about, How to Solve Oracle Database Error ORA-01407, ORA-01407 error code, ORA-01407 problem, Oracle 9i 10g 11g, Oracle Database Server Error Messages, Oracle Error Codes, oracle number 1407 error code, oracle ORA-01407 example
No Comment Yet
No Comment Yet
Recent Entries
- Oracle database error code ORA-29959 – error in the execution of the string routine for one or more of the index partitions
- Oracle database error code ORA-31601 – Function string cannot be called now that fetch has begun.
- Oracle database error code ORA-29958 – fatal error occurred in the execution of ODCIINDEXCREATE routine
- Oracle database error code ORA-31600 – invalid input value string for parameter string in function string
- Oracle database error code ORA-29957 – cannot create a function-based domain index on a string table
- Oracle database error code ORA-31604 – invalid string parameter “string” for object type string in function string
- Oracle database error code ORA-29961 – too many warnings occurred in the execution of ODCIIndex DDL routine
Search Oracle Error Codes and Descriptions:
Be The First To Comment
Similar Errors
Please Leave Your Comments Below