ORA-01767

Error: ORA-01767: UPDATE ... SET expression must be a subquery

Causa: An attempt was made to use a single expression without a subquery to update a list of columns.

Acción: Check the syntax for using subqueries to update data and add the necessary subquery.