ORA-02064 distributed operation not supported
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-02064 distributed operation not supported

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Jeff,
    You are a blessing!
    Thanks mate...
    Hemant

  4. #4
    Join Date
    Mar 2006
    Location
    Philadelphia
    Posts
    1

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

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width