Page 1 of 1

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

Posted: Fri 20 Nov 2009 22:19
by smuddasu
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 ?

Posted: Mon 23 Nov 2009 13:12
by Shalex
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.