I'm using Corelab.Oracle in Version 4.30.25.0. Now, if I execute a C#-code like this
Code: Select all
// get a factory for database-access
IDatabase dbsThis = Tools.GetDefaultDatabase();
IDbCommand cmdThis = dbsThis.GetCommandObject();
cmdThis.CommandText = @"INSERT INTO TBL_CASE_MEMOS (FK_CASE, MEMO_TEXT, FK_EDITOR) VALUES (:1, :2, :3)";
cmdThis.Parameters.Add(dbsThis.GenerateParameter("1", DbType.Int32, 8545, ParameterDirection.Input));
cmdThis.Parameters.Add(dbsThis.GenerateParameter("2", DbType.String, "Test", ParameterDirection.Input));
cmdThis.Parameters.Add(dbsThis.GenerateParameter("3", DbType.Int32, 1851, ParameterDirection.Input));
MessageBox.Show(cmdThis.ExecuteNonQuery().ToString());
But if I call the same code inside a transaction I get 0 as the return value of ExecuteNonQuery(). Is there any known issue about this behaviour?
Thx, Alex[/code]