0

We are having trouble executing scripts that begin with BEGIN and are having multiple procedures or triggers with the aforementioned provider. Execution of those fails. Has anyone eperienced similiar problems?

Improve this question
1
  • Can you supply some more information, for example: error codes and/or sample code that always fails, thanks Commented Feb 20, 2009 at 11:45

1 Answer 1

Reset to default
2

I believe that is a 'feature' of MS DPO.

The Oracle database does not support multiple transactions on a single connection—they are always scoped at the connection level. Accordingly, ODP.NET propagates a transaction to commands executed on the connection. The Microsoft provider requires you to explicitly assign the transaction to each command.

(from MSDN: Comparing the Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NET)

Consider using ODP.NET if you can.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.