problem with ODP.NET and transactions
Having a problem with the ODP.NET data provider when using transactions. Here is a simple example to reproduce the problem.
OraConnection LConnection = new OraConnection();
try
{
LConnection.ConnectionString = "<Your data here>";
LConnection.Open();
OraTransaction LTransaction = LConnection.BeginTransaction();
OraCommand LCommand = LConnection.CreateCommand();
LCommand.CommandText = "create table Test ( id int not null primary key )";
LCommand.Transaction = LTransaction;
LCommand.ExecuteNonQuery();
LTransaction.Commit();
}
finally
{
LConnection.Dispose();
}
This example throws an InvalidOperatorException when the transaction is committed. This same sequence of commands works with other ADO.NET data providers.
Has anyone seen this? Is this a known issue, or am I doing something wrong.
Thanx,
Bryn Rhodes
Alphora