Calling Oracle Text Packaged Procedure Fails With ORA-2074
Last updated on JULY 17, 2017
Applies to:Oracle Data Provider for .NET - Version 126.96.36.199 and later
Information in this document applies to any platform.
*** Checked for relevance on 17-Jul-2017 ***
Using the Oracle Data Provider for .NET (ODP.NET) to call a packaged procedure specific to Oracle Text fails with the following errors:
ORA-20000: Oracle Text error:
ORA-02074: cannot ROLLBACK in a distributed transaction
Other error messages that may result include the following:
ORA-02074: cannot SET SAVEPOINT in a distributed transaction
ORA-02074: cannot COMMIT in a distributed transaction
ORA-02074: cannot SET NLS in a distributed transaction
This error can occur when calling an Oracle Text-specific packaged procedure, such as CTX_DOC.MARKUP, from a Visual Studio .NET application using ODP.NET.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms