Re: Oracle Rollback causing error with .NET 1.1

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

There are just so many reasons why this could be happening - are you using
MSDTC? ENterprise Services?

SM


"Khurram" <Khurram@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:47856EDD-5328-48B3-A83A-7299F021330F@xxxxxxxxxxxxxxxx
Hi,

I am calling a DBMS_Transaction.ReadWrite(); and later Rollback; from an
Oracle Stored Procedure. When I call this stored procedure with from an
ASP.NET page, using OracleClient.dll version 1.0.3.000 i get NO ERROR, but
when i use OracleClient.dll version 1.0.5.000 i get this ERROR;
"ORA-02074: cannot ROLLBACK in a distributed transaction".

Following is my configuration:
Windows XP, IIS 5.1
VS 2003, .NET framework 1.1
Oracle 9i Release 2

I have googled, tried searching MSDN but no one has given specific
resolution of the said issue although they say it is an issue :P.
Any insight will be most welcome ...



.

Relevant Pages

  • Re: AutoCommit - Oracle.
    ... If you have a rollback in your stored procedure you would need a begintrans ... I really don't see having begintrans somewhere and rollback elsewhere. ... > Is the same true for an Oracle Stored procedure? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle Stored Procedure
    ... I created a simple procedure on my oracle database ... There's an example of calling a stored procedure on the OCI8 manual page. ...
    (comp.lang.php)
  • AutoCommit - Oracle.
    ... If you call a stored procedure which is an update procedure, ... Is the same true for an Oracle Stored procedure? ... indicates that I can not do a rollback on a distributed transaction. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DBD::Sybase and $sth->{syb_result_type} v. DBD::ODBC (Sql Server)
    ... write output parameters and return a value. ... individual operations in the procedure by calling odbc_more_results. ... Things get a little more complex for what I guess Sybase calls CS_MSG_RESULT ... the status from a stored procedure was ...
    (perl.dbi.users)
  • Re: [PHP] Stored Procedure returns nothing on ROLLBACK
    ... I have a stored procedure that I call in PHP using mssql_* functions. ... The output parameter also does not get set upon rollback. ...
    (php.general)