Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

OCI-14359

The operation was unable to obtain a consistent set of rows that needed to be modified.

Cause

A consistent set of rows needing modifications could not be obtained as the WHERE clause was non-deterministic and also, large concurrent DML possibly modified WHERE clause columns. The WHERE clause was non-deterministic because it contained an operand that, when given the same input parameters, did not always return the same output value.


Action

Remove any non-deterministic operand in the WHERE clause and reissue the DML.