ORA-01453: SET TRANSACTION must be first statement of transa

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
smuddasu
Posts: 9
Joined: Wed 16 Sep 2009 19:53

ORA-01453: SET TRANSACTION must be first statement of transa

Post by smuddasu » Fri 20 Nov 2009 22:19

Hello,
I am getting this error from web service that uses dotconnect for oracle. here is the scenario...Lets say ..i make a request to web service and the contextobject.savechagnes() failes because of some FK issues. I fix the value to avoid the FK issues and make a second request, then i get this error on calling Savechanges().
If i wait for couple seconds before making the second request, at that time, savechanges() doesnot fail.

Could you please help ?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 23 Nov 2009 13:12

It can be the problem of native Entity Framework or our provider's issue. We need the test project to reproduce the problem in our test environment. Please send us a test project with the DDL/DML script via our contact form.

Post Reply