Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

ORA-42603

Cannot update JSON Relational Duality View 'string': The Primary Key column(s) of the root table 'string' cannot be updated, omitted, or set to NULL.

Cause

An attempt was made to modify the primary key column(s) of the root table, which is not allowed. Additionally, the input primary key column(s) cannot be missing or NULL because that modifies the primary key column(s) to NULL.


Action

Add or modify the WHERE clause in the UPDATE statement so that the root primary key column(s) of the input duality view object matches the primary key column(s) of the object being modified. Alternatively, modify the primary key column(s) of the new object such that it matches the primary key column(s) of the object being modified.