I have a proc which invokes a remote proc which has a commit in it.
I get this error:
ORA-02064 distributed operation not supported
A commit is issued in a coordinated session from an RPC with OUT parameters.
When I take out the commit from the remote procedure, it works but not when I have the commit.
What do I do about this?
You either need to commit outside your RPC or have an autonomous transaction inside your RPC. http://technet.oracle.com/docs/produ...08sql.htm#8266
You are a blessing!
Once again, you saved the day...
I, too, was having difficulties with a distributed transaction. Does anyone know Oracle's rationale for not allowing a remote proc to not perform commits? Is it because it was too difficult for them to have the commit actions synchronized if they could be performed in more than one location? Operators are standing by waiting for your answers...
Thanks for digging up this old thread.
If you think about it, remote commits don't make sense. The transaction is initiated on one side, why should the other side be allowed to take over control of that transaction?
Click Here to Expand Forum to Full Width