Oracle Message ORA-02064 - distributed operation not supported

ERRORdistributed operation not supported
CAUSEOne of the following unsupported operations was attempted: 1. array execute of a remote update with a subquery that references a dblink, or 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, or 3. a commit is issued in a coordinated session from an RPC procedure call with OUT parameters or function call.
ACTIONsimplify remote update statement