Oracle Error Codes

cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

An attempt was made to SELECT… FOR UPDATE from a view whose defining SELECT statement uses at least one of the following constructs in its outer block: outer join, GROUP BY clause, aggregate functions, SELECT DISTINCT, CONNECT BY clause, or set operation, UNION, INTERSECT, or MINUS.

How to Solve :

Do not use SELECT… FOR UPDATE on this view.