Database Error Messages

ORA-01786

FOR UPDATE cannot be used with feature_name
  • feature_name: The feature that FOR UPDATE cannot be used with.

Cause

An attempt is being made to use a FOR UPDATE clause on the result of a set expression involving GROUP BY, DISTINCT, UNION, INTERSECT, MINUS, or QUALIFY.


Action

Check the syntax, remove the FOR UPDATE clause, and retry the statement.