-
Hi gurus,
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
Cause:
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?
Hemant
-
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
Jeff Hunter
-
Jeff,
You are a blessing!
Thanks mate...
Hemant
-
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?
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|