I am trying to Call a Oracle (8.1.7) Stroed procedure from Vb.Net. The stored procedure has transaction. After sucessful completion of one Insert statement a record is inserted into a second table else rollback everyting. I am using OracleClient ( Dim OraClientCon As New OracleClient.OracleConnection). Whenever transaction rollback, I get ora-02074. I never initiated Distributed Transaction. From where it is comming from????
I have alternativly used OLEDB (Dim OleCon As New OleDb.OleDbConnection). I got the same result, but when I disabled Distributed Transaction by setting distribtx=0 in connectionstring, all gets well.
I am unable to find equilevant parameter for OracleClient. I have tried Enlist=False but no luck!!!