DevOps, CI/CD and Automation

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!

ORA-02074: cannot SET NLS in a distributed transaction in OLEDB (works in MS OLEDB)

233833Jul 26 2002

I try to do a DBMS_SESSION('NLS','''DD/MM/YYYY''');
from VB.NET (Oracle Data Provider for OLEDB 9.2)

and crash with following error (occurs immediately after connecting:

"ORA-02074: cannot SET NLS in a distributed transaction
ORA-06512: at "SYS.DBMS_SESSION", line 101
ORA-06512: at line 1"

When I try exactly the same with the Microsoft OLEDB provider, this works without a problem.

DB is 8.1.7 and is NOT a distributed database, I can also issue this statemnent with sqlplus without any problems.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2002

Added on Jul 26 2002

#oracle-provider-for-ole-db, #windows-and-net

2 comments

1,538 views