Link to home
Start Free TrialLog in
Avatar of qaziasif
qaziasif

asked on

VB.NET and Oracle ora-02074

Hi ALL

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!!!

Please help.
 
ASKER CERTIFIED SOLUTION
Avatar of glsac
glsac
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial