OracleClient .NET Rollback In SP

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ahmet (akgun_ahmet_at_hotmail.com)
Date: 05/14/04


Date: Fri, 14 May 2004 21:52:37 +0300

Hi All

I am developing a database application on Oracle 8.1.7
I have two types of programs one of which is C++ servers
and the other one is C# client froms.

On database I have SP and calling them from both server and client.

In my sp code, there is one Rollback statement in case of an error
and when this sp is called from C++ code (using OCI API) there is no error.

But while calling with c# (OracleClient), I always get error,
"Rollback is not allowed in distributed transactions !!".

Can anybody help me how to overcome this issue

Kind Regards...



Relevant Pages

  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... database 9.2.0 enterprise edition. ...
    (comp.databases.oracle.server)
  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... database 9.2.0 enterprise edition. ... could justify for having many installations of Oracle 9.2.0.x would be ...
    (comp.databases.oracle.server)
  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... database 9.2.0 enterprise edition. ... could justify for having many installations of Oracle 9.2.0.x would be ...
    (comp.databases.oracle.server)
  • Re: changing domain name
    ... Cris Carampa wrote: ... > I'm reorganizing my company's network, so all the Oracle servers will be ... and it is only one command per database (alter database ...
    (comp.databases.oracle.server)
  • Re: Delphi bugs and "moving" to Visual Studio debate
    ... Even the origins of the name Delphi ... " The strategic decision to make database tools and connectivity a central ... Gary kept coming back to the codename "Oracle", ... connectivity to Oracle servers. ...
    (borland.public.delphi.non-technical)