Home » SQL & PL/SQL » SQL & PL/SQL » dblink between 10g and 9i (aix)
dblink between 10g and 9i [message #308559] Mon, 24 March 2008 21:08 Go to next message
Messages: 1
Registered: March 2008
Location: shijiazhuang
Junior Member

dblink from 9i to 10g is ok,but when i run a procedure at 10g,have a error is :ora-02064:distributed operation not supported.
Re: dblink between 10g and 9i [message #308572 is a reply to message #308559] Mon, 24 March 2008 23:13 Go to previous message
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

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

[Updated on: Mon, 24 March 2008 23:16]

Report message to a moderator

Next Topic: Complex Case Expression
Goto Forum:

Current Time: Tue Oct 25 14:23:07 CDT 2016

Total time taken to generate the page: 0.14234 seconds