c# 执行ORACLE存储过程并返回行数

来源:互联网 发布:rhino执行js方法 编辑:程序博客网 时间:2024/05/21 18:08
            using (OracleConnection connection = new OracleConnection(connectionString))
            
{
                OracleCommand Ocmd 
= new OracleCommand("存储过程名", connection);
               
//执行等待超时时间
                Ocmd.CommandTimeout = 30;

                Ocmd.CommandType 
= CommandType.StoredProcedure;

                OracleParameter Oparam;

                            Oparam 
= Ocmd.Parameters.Add("参数1", OracleType.VarChar);
                            Oparam.Value 
= 变量值1;
                             Oparam 
= Ocmd.Parameters.Add("参数2",OracleType.Int32);
                            Oparam.Value 
= 变量值12;
    
              
try
                
{
                    connection.Open();
                    
int rows = Ocmd.ExecuteNonQuery();
                    
return rows;
                }

                
catch (OracleException E)
                
{
                    
throw new Exception(E.Message);
                }

                
finally
                
{
                    Ocmd.Dispose();
                    connection.Close();
                }

            }

 
原创粉丝点击