Oracle中的ExecuteNonQuery问题 [英] Problem with ExecuteNonQuery in oracle

问题描述

嗨伙计，



我在Oracle中遇到了ExecuteNonQuery方法的问题。

Hi Folks,

I am facing a problem with ExecuteNonQuery method in Oracle.

oraConnection = new Oracle.DataAccess.Client.OracleConnection(_connectionString);

Oracle.DataAccess.Client.OracleCommand cmd= new Oracle.DataAccess.Client.OracleCommand("Update tableA set Name='Anand' where Id=25005', oraConnection);

      orda.UpdateCommand = cmd;
      cmd.CommandType = CommandType.Text;
      cmd.CommandTimeout = 0;
      oraConnection.Open();
      rowAfected = cmd.ExecuteNonQuery(); 

在ExecuteNonQuery上，我的应用程序被挂起，看起来操作仍在进行中。



任何帮助都是赞。

On ExecuteNonQuery my application got hanged looks like operation is still in progress.

Any help is appreciated.

推荐答案

您缺少一个关闭指令：

You are missing a close directive:

oraConnection.Open();
rowAfected = cmd.ExecuteNonQuery(); 
oraConnection.Close();

这篇关于Oracle中的ExecuteNonQuery问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！