ORA-02074: cannot ROLLBACK in a distributed transaction
450721Aug 22 2005 — edited Aug 23 2005Hi,
I'm using ODP.NET 10.1.0.4.0 to access Oracle 8.1.7.4.1
when I try to execute any stored procedure that have "rollback" command, for example:
procedure aproc
as
begin
insert into table1 values(0);
rollback;
end;
then I get the following exception: "ORA-02074: cannot ROLLBACK in a distributed transaction". I tried to add "Enlist=False" to my connectionstring but it isn't affected.
Can someone show me the correct way?
Thank for any help.