ORA-02064 distributed operation not supported

[hemanr]

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?

[marist89]

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

[hemanr]

Jeff,
You are a blessing!
Thanks mate...

[plexiboy]

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...

[marist89]

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?