Re: Q: "Distributed operation not supported" error

I found this in the Oracle 8.1.6 manual (in the Oracle 7 manual, the

message is different):

ORA-02064 distributed operation not supported Cause: One of the following unsupported operations was attempted: n Array execute of a remote update with a subquery that references a database link, or
n An update of a long column with bind variable and an update of a secon d
column with a subquery that both references a database link and a bind variable, or
n A commit is issued in a coordinated session from an RPC with OUT parameters.
Action: Simplify the remote update statement.

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-11-22, 21:48:52, schreef NO gaverill_at_chsra.wisc.edu SPAM (Gerard  

Averill) over het thema Q: "Distributed operation not supported" error:

> I'm receiving this error when calling a packaged procedure through a
> database link. (I don't have the error number and haven't been able t
 o
> find the error in the manuals.) What's not clear to me: does this err
 or
> indicate that the remote procedure is attempting to perform an operati
 on
> that cannot be performed remotely; or, that remote procedure calls are
 

not
> supported (perhaps because some Distributed Option is not installed?)

> BTW, both local and remote databases are Oracle 7.3.4 running on NT4.0
 

> servers.
 

> Any help is appreciated...
Received on Thu Nov 23 2000 - 00:36:52 CST