I am attempting to set a value in one table to a value that I get from another table. The source table does not contain any null values in it but Oracle returns the following message each time I try.
SQL Error: ORA-01407: cannot update ("MXDB"."JOBPLAN"."JPDURATION") to NULL
01407. 00000 - "cannot update (%s) to NULL"
This is the SQL that I'm using:
update jobplan JP
set JP.jpduration =
from tmp_hours TMP
where JP.jpnum = TMP.jpnum);
The TMP_HOURS table has only two columns: jpnum and laborhrs. Neither column contains null in any row.
The JOBPLAN table has many columns, two of which are jpnum and jpduration.
I am trying to set jobplan.jpduration to TMP_HOURS.laborhrs.
There is a matching record in the JOBPLAN table for every record in the TMP_HOURS table.
Any ideas what is going on?
The laborhrs and jpduration fields are both float.