Database Error Messages

ORA-42605

Cannot update JSON Relational Duality View 'string': cannot modify the same row of the table 'string' more than once.

Cause

An attempt was made to modify the same row of the specified table more than once. This could happen if the same row was part of two or more documents being updated by the current statement. Such operations were disallowed because the order in which the documents get updated could impact the final value of the row, leading to non-deterministic results.


Action

Add or modify the where clause so that it targets a single document or a set of documents with no overlapping rows. Alternatively, use a different duality view to perform this operation, such as one with the specified table as the root table.