111,096
社区成员




object objChart;
OracleParameter p1 = new OracleParameter("f1", OracleDbType.Int32, 100, 5, ParameterDirection.Input);
OracleParameter p2 = new OracleParameter("f2", OracleDbType.Varchar2, 100, "", ParameterDirection.Output);
OracleParameter p3 = new OracleParameter();
p3.OracleDbType = OracleDbType.Int32;
p3.Direction = ParameterDirection.ReturnValue;
OracleParameter[] cmdParm1 = new OracleParameter[] {p3, p1, p2 };
OracleDBHelper.ExecuteNonQuery("functionName", System.Data.CommandType.StoredProcedure, cmdParm1);
objChart = p3.Value;
return objChart;
object objChart;
OracleParameter p1 = new OracleParameter("f1", OracleDbType.Int32, 100, 5, ParameterDirection.Input);
OracleParameter p2 = new OracleParameter("f2", OracleDbType.Varchar2, 100, "", ParameterDirection.Output);
OracleParameter p3 = new OracleParameter();
p3.OracleDbType = OracleDbType.Int32;
p3.Direction = ParameterDirection.ReturnValue;
OracleParameter[] cmdParm1 = new OracleParameter[] { p1, p2, p3 };
OracleDBHelper.ExecuteNonQuery("functionName", System.Data.CommandType.StoredProcedure, cmdParm1);
objChart = p3.Value;
return objChart;
会报ora-01403:未找到任何数据 的错误。
OracleConnection con = new OracleConnection("");
OracleCommand cmd = new OracleCommand();
OracleParameter p1 = new OracleParameter("f1", OracleType.Int32);
p1.Direction = ParameterDirection.Input;
p1.Value = 5;
OracleParameter p2 = new OracleParameter("f2", OracleType.VarChar);
p2.Direction = ParameterDirection.Output;
p2.Value = "f";
OracleParameter p3 = new OracleParameter();
p3.OracleType = OracleType.Int32;
p3.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Connection = con;
cmd.CommandText = "function1";
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
con.Close();