ExecuteNonQuery() returns 0

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
sprinter252
Posts: 23
Joined: Fri 16 Nov 2007 20:10
Location: Germany

ExecuteNonQuery() returns 0

Post by sprinter252 » Wed 05 Dec 2007 15:31

Hello,

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());
I'll get a messagebox with the value "1" -> thats what I expect!!! :D

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]

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Thu 06 Dec 2007 13:43

We cannot reproduce this problem. Please send us complete sample to demonstrate it and include script
to create server objects.

Post Reply