Q
Problem solve Get help with specific problems with your technologies, process and projects.

ORA-2064 error

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:

  1. An array execute of a remote update with a subquery that references a database link.
  2. 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.
  3. 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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close