ORA-01786

Error: ORA-01786: FOR UPDATE of this query expression is not allowed

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

Acción: Check the syntax, remove the FOR UPDATE clause, and retry the statement.