I am getting the error, "ORA-2064: distributed operation not supported across a database link." The confusing part is that everything works to a certain point, inserting across the link, and then I get this error. Any ideas what could be causing this?
You get the ORA-2064 error when you attempt to do one of the following:
- An array execute of a remote update with a subquery that references a database link.
- An update of a long column with bind variable and an update of a second column with a subquery that references both a database link and a bind variable.
- a commit in a coordinated session issued from a remote procedural call with OUT parameters.
Fix which ever one applies, and you will no longer see the ORA-2064 error. Without seeing the actual SQL statement, it is difficult to tell which operation is tripping you up.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.