Oracle Solution for Error ora-02064

ORA-02064: distributed operation not supported

What triggered the Error:

One of the following unsupported operations was attempted: *1. array execute of a remote update with a subquery that references a dblink, o. *2. an update of a long column with bind variable and an update of a second column with a subquery that both references a dblink and a bind variable, o. *3. a commit is issued in a coordinated session from an RPC procedure call with OUT parameters or function call.

What should we do to fix it:

simplify remote update statement