public string Test()
{
try
{
Open();
OracleCommand cmd = new OracleCommand("htfcrm2.htf_insertsms", con);
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter p1 = new OracleParameter("p_MOBILE", OracleType.Char, 40);
p1.Direction = System.Data.ParameterDirection.Input;
p1.Value = "12312341234";
OracleParameter p2 = new OracleParameter("p_CONTENT", OracleType.Char, 2000);
p2.Direction = System.Data.ParameterDirection.Input;
p2.Value = "测试";
OracleParameter p3 = new OracleParameter("p_priority", OracleType.Char, 1);
p3.Direction = System.Data.ParameterDirection.Input;
p3.Value = "1";
OracleParameter p4 = new OracleParameter("p_custname", OracleType.Char, 60);
p4.Direction = System.Data.ParameterDirection.Input;
//p4.Value = "";
OracleParameter p5 = new OracleParameter("p_sysname", OracleType.Number, 20);
p5.Direction = System.Data.ParameterDirection.Input;
p5.Value = 4;
OracleParameter p6 = new OracleParameter("p_limitDateS", OracleType.Char, 10);
p6.Direction = System.Data.ParameterDirection.Input;
p6.Value = "2011-03-01";
OracleParameter p7 = new OracleParameter("p_limitDateE", OracleType.Char, 10);
p7.Direction = System.Data.ParameterDirection.Input;
p7.Value = "2011-03-01";
OracleParameter p8 = new OracleParameter("p_LIMMITTIMES", OracleType.Number, 4);
p8.Direction = System.Data.ParameterDirection.Input;
p8.Value = 100;
OracleParameter p9 = new OracleParameter("p_LIMMITTIMEE", OracleType.Number, 4);
p9.Direction = System.Data.ParameterDirection.Input;
p9.Value = 1439;
OracleParameter p10 = new OracleParameter("p_maxLength", OracleType.Number, 3);
p10.Direction = System.Data.ParameterDirection.Input;
p10.Value = 70;
OracleParameter p11 = new OracleParameter("p_custno", OracleType.Char, 40);
p11.Direction = System.Data.ParameterDirection.Input;
//p11.Value = "";
OracleParameter p12 = new OracleParameter("p_custSrcSys", OracleType.Char, 40);
p12.Direction = System.Data.ParameterDirection.Input;
//p12.Value = "";
OracleParameter p13 = new OracleParameter("p_filterHe", OracleType.Char, 1);
p13.Direction = System.Data.ParameterDirection.Input;
//p13.Value = "";
OracleParameter p14 = new OracleParameter("p_filterUnsmsUser", OracleType.Char, 1);
p14.Direction = System.Data.ParameterDirection.Input;
//p14.Value = "";
OracleParameter p15 = new OracleParameter("p_filterUmsmsMobile", OracleType.Char, 1);
p15.Direction = System.Data.ParameterDirection.Input;
//p15.Value = "";
OracleParameter p16 = new OracleParameter("p_out ", OracleType.Char, 200);
p16.Direction = System.Data.ParameterDirection.ReturnValue;
p16.Value = ""; cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Parameters.Add(p5);
cmd.Parameters.Add(p6);
cmd.Parameters.Add(p7);
cmd.Parameters.Add(p8);
cmd.Parameters.Add(p9);
cmd.Parameters.Add(p10);
cmd.Parameters.Add(p11);
cmd.Parameters.Add(p12);
cmd.Parameters.Add(p13);
cmd.Parameters.Add(p14);
cmd.Parameters.Add(p15);
cmd.Parameters.Add(p16); cmd.ExecuteNonQuery(); return p16.Value.ToString(); }
参数名可以确保没有问题... 到底是哪出错了?
求解...
{
try
{
Open();
OracleCommand cmd = new OracleCommand("htfcrm2.htf_insertsms", con);
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter p1 = new OracleParameter("p_MOBILE", OracleType.Char, 40);
p1.Direction = System.Data.ParameterDirection.Input;
p1.Value = "12312341234";
OracleParameter p2 = new OracleParameter("p_CONTENT", OracleType.Char, 2000);
p2.Direction = System.Data.ParameterDirection.Input;
p2.Value = "测试";
OracleParameter p3 = new OracleParameter("p_priority", OracleType.Char, 1);
p3.Direction = System.Data.ParameterDirection.Input;
p3.Value = "1";
OracleParameter p4 = new OracleParameter("p_custname", OracleType.Char, 60);
p4.Direction = System.Data.ParameterDirection.Input;
//p4.Value = "";
OracleParameter p5 = new OracleParameter("p_sysname", OracleType.Number, 20);
p5.Direction = System.Data.ParameterDirection.Input;
p5.Value = 4;
OracleParameter p6 = new OracleParameter("p_limitDateS", OracleType.Char, 10);
p6.Direction = System.Data.ParameterDirection.Input;
p6.Value = "2011-03-01";
OracleParameter p7 = new OracleParameter("p_limitDateE", OracleType.Char, 10);
p7.Direction = System.Data.ParameterDirection.Input;
p7.Value = "2011-03-01";
OracleParameter p8 = new OracleParameter("p_LIMMITTIMES", OracleType.Number, 4);
p8.Direction = System.Data.ParameterDirection.Input;
p8.Value = 100;
OracleParameter p9 = new OracleParameter("p_LIMMITTIMEE", OracleType.Number, 4);
p9.Direction = System.Data.ParameterDirection.Input;
p9.Value = 1439;
OracleParameter p10 = new OracleParameter("p_maxLength", OracleType.Number, 3);
p10.Direction = System.Data.ParameterDirection.Input;
p10.Value = 70;
OracleParameter p11 = new OracleParameter("p_custno", OracleType.Char, 40);
p11.Direction = System.Data.ParameterDirection.Input;
//p11.Value = "";
OracleParameter p12 = new OracleParameter("p_custSrcSys", OracleType.Char, 40);
p12.Direction = System.Data.ParameterDirection.Input;
//p12.Value = "";
OracleParameter p13 = new OracleParameter("p_filterHe", OracleType.Char, 1);
p13.Direction = System.Data.ParameterDirection.Input;
//p13.Value = "";
OracleParameter p14 = new OracleParameter("p_filterUnsmsUser", OracleType.Char, 1);
p14.Direction = System.Data.ParameterDirection.Input;
//p14.Value = "";
OracleParameter p15 = new OracleParameter("p_filterUmsmsMobile", OracleType.Char, 1);
p15.Direction = System.Data.ParameterDirection.Input;
//p15.Value = "";
OracleParameter p16 = new OracleParameter("p_out ", OracleType.Char, 200);
p16.Direction = System.Data.ParameterDirection.ReturnValue;
p16.Value = ""; cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Parameters.Add(p5);
cmd.Parameters.Add(p6);
cmd.Parameters.Add(p7);
cmd.Parameters.Add(p8);
cmd.Parameters.Add(p9);
cmd.Parameters.Add(p10);
cmd.Parameters.Add(p11);
cmd.Parameters.Add(p12);
cmd.Parameters.Add(p13);
cmd.Parameters.Add(p14);
cmd.Parameters.Add(p15);
cmd.Parameters.Add(p16); cmd.ExecuteNonQuery(); return p16.Value.ToString(); }
参数名可以确保没有问题... 到底是哪出错了?
求解...
p16.Direction = System.Data.ParameterDirection.ReturnValue;
p16.Value = "";p_out后面多个空格