ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODP.NET Procedure w/Transaction Error

431140Dec 22 2004 — edited Jan 12 2005

I am having a problem executing a stored procedure in a package from ODP.NET.

I receive the error:

0- ORA-02074: cannot ROLLBACK in a distributed transaction ORA-06512: at "<DATABASE_NAME>.<PACKAGE_NAME>", line 513 ORA-02074: cannot SET SAVEPOINT in a distributed transaction ORA-06512: at line 1

(note that line 513 in the package is where the "ROLLBACK" statement is if an exception is thrown)

I'm using ODP 10.1.0.3 and Oracle 8.1.7 Database

I did note that I was able to execute this sucessfully on a Oracle 9i server using ODP, and the procudure runs fine from within the 817 Database (using PL/SQL Developer).

I came across the following link but am not sure how to implement the given workaround with ODP, and I am not able to find the bug or patch that is spoken of:

http://www.dotnet247.com/247reference/msgs/39/197274.aspx

Thanks for any assistance that can be provided.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2005

Added on Dec 22 2004

#odp-net

2 comments

384 views