c oracle语句传参,c# 执行调用Oracle Procedure传参及回传值

定義參數               //IDataParameter[] parameters =               //             {               //                 new OracleParameter(":p_stage",OracleDbType.Varchar2,model.Stage,ParameterDirection.Input),//传值               //                  new OracleParameter(":ReturnValue",ParameterDirection.Output)//回传               //             };               參數賦值               parameters[0].Value = model.Stage;               //string prconn = System.Configuration.ConfigurationManager.AppSettings["DBConnStr_tnboa1insert"];               //OracleConnection conn = new OracleConnection(prconn);               //conn.Open();               //OracleCommand cmd = new OracleCommand("PRO__SETTLEMENT",conn);  //Procedure &连接数据库               //cmd.CommandType = CommandType.StoredProcedure;               //cmd.Parameters.AddRange(parameters);               //OracleDataAdapter oda = new OracleDataAdapter(cmd);               //DataTable dt = new DataTable();               //oda.Fill(dt);               //conn.Close();               //string iReturn = cmd.Parameters["RETURNVALUE"].Value.ToString();               return ds.Tables[0];              // string iReturn = ConnInstance.ExecuteQuery_Sp("PRO_SETTLEMENT",parameters);//执行完成后得到回传的结果               DataTable dt = new DataTable();               string prconn = System.Configuration.ConfigurationManager.AppSettings["DBConnStr_tnboa1insert"];               OracleConnection conn = new OracleConnection(prconn);               conn.Open();               OracleCommand cmd = new OracleCommand("PRO_SETTLEMENT",conn);  //Procedure&连接数据库               //cmd.CommandText = "PRO_SETTLEMENT";  //Procedure                cmd.CommandType = CommandType.StoredProcedure;               cmd.Parameters.Add("P_STAGE",OracleDbType.Varchar2).Direction = ParameterDirection.Input;//传值类型定义                cmd.Parameters["P_STAGE"].Value = model.Stage;//赋值                cmd.Parameters.Add("RETURNVALUE",200).Direction = ParameterDirection.Output;//回传  注：回传定义字符长度，忽略会报错                cmd.ExecuteNonQuery();                string iReturn = cmd.Parameters["ReturnValue"].Value.ToString();执行完成后得到回传的结果                conn.Close();