Error: ORA 1786
Text: FOR UPDATE of this query expression is not allowed
-------------------------------------------------------------------------------
Cause: 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.
Action: Check the syntax, remove the FOR UPDATE clause, and retry the
statement.