Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-02064

distributed operation not supported

Cause

One 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.

Action

simplify remote update statement