Adsense Ad

Thursday 17 August 2017

Oracle: ORA-02064 Error Message

Error Description:
Distributed operation not supported
Error 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.

No comments: