参数长度过小导致数据库传值失败

来源:互联网 发布:smali to java 在线 编辑:程序博客网 时间:2024/05/16 09:22

参数中的大小设置过小,导致程序无法将正确的值传到数据库中执行, 在此写明, 引以为戒, 望大家也少犯类似基本错误.

int ReturnValue = 0;        string ReturnMsg = string.Empty;        try        {            DBCon dbc = new DBCon();            OracleParameter[] parameters = new OracleParameter[] {dbc.CreatOutPara("O_RETURNVALUE", OracleType.Number,8),                                            dbc.CreatOutPara("O_RETURNMSG", OracleType.VarChar ,30),                                            dbc.CreatInPara("I_WOID", OracleType.VarChar,  8 ,woid),                                            dbc.CreatInPara("I_ROUTINGID", OracleType.VarChar,30,RightRoutingID)                                                                                       };            dbc.ExecProc("ADATA_PAC_ABNORMAL.PROC_CorrectRouting", parameters);

            ReturnValue = int.Parse(parameters[0].Value.ToString());            ReturnMsg = parameters[1].Value.ToString();        }        catch (Exception ex)        {            Alert(GetRequestFilename() + "页面修改途程时更新数据库出现异常,异常信息:" + ex.Message + "请联系MES人员.");            return;        }

        if (ReturnValue == 1)        {            Alert(ReturnMsg);        }        else        {            Alert(ReturnMsg);        }        //更新工单与路单信息        GetRuncardID(woid);

原创粉丝点击