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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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