Hi,

I am trying to update a non nullable column with certain values and am getting this error.

There are no null values but still i am getting this error


SQL> update news_storytest set PRODUCT_LOCATION_ID = (select NEW_PRODUCT_LOCATION_ID
2 from story_product_map where
3 story_product_map.STORY_ID = news_storytest.story_id);
update news_storytest set PRODUCT_LOCATION_ID = (select NEW_PRODUCT_LOCATION_ID
*
ERROR at line 1:
ORA-01407: cannot update ("COMPANY"."NEWS_STORYTEST"."PRODUCT_LOCATION_ID") to
NULL


Here is the query which proves that there are no null values in the story_product_map table
SQL> select count(*) from story_product_map where NEW_PRODUCT_LOCATION_ID is null;

COUNT(*)
----------
0


Please suggest