Oracle Error ORA-40119: nested columns incompatible with missing value treatment

Oracle Error Message

ORA-40119: nested columns incompatible with missing value treatment

Reason for the Error

delete_row missing value treatment is not supported for nested columns.

Solution

Use 2D (non-nested) data representation or manually delete the rows with NULL values and disable the delete_row missing value treatment.