当前位置：Gxlcms > 数据库问题 > C# 获取 oracle 存储过程的返回值

C# 获取 oracle 存储过程的返回值

时间：2021-07-01 10:21:17 帮助过：3人阅读

‘YYYY-MM-DD hh24:mi:ss‘), OBJESECT_parms, OBJECONTENT_parms, ISRELEASE_parms, OBJECODE_parms, TAGS_parms) RETURN OBJEID INTO OBJ_ID_parms; RETURN; EXCEPTION WHEN NO_DATA_FOUND THEN NULL; WHEN OTHERS THEN -- Consider logging the error and then re-raise RAISE; END INSERT_OBJ;

C#中获取值

                DbParameter[] paras = new OracleParameter[8];
                paras[0] = new OracleParameter("OBJEFIRT_parms", OracleType.NVarChar);
                paras[0].Value = cbinf.ObjeFirT;
                paras[1] = new OracleParameter("OBJEDATT_parms", OracleType.NVarChar);
                paras[1].Value=cbinf.ObjeDatT.ToString();
                paras[2]= new OracleParameter("OBJESECT_parms",OracleType.NVarChar);
                paras[2].Value = cbinf.ObjeSecT;
                paras[3] = new OracleParameter("OBJECONTENT_parms", OracleType.NVarChar);
                paras[3].Value = cbinf.ObjeContent;
                paras[4] = new OracleParameter("ISRELEASE_parms", OracleType.Int32);
                paras[4].Value = cbinf.IsRelease;
                paras[5] = new OracleParameter("OBJECODE_parms", OracleType.NVarChar);
                paras[5].Value = cbinf.ObjeCode;
                paras[6] = new OracleParameter("TAGS_parms", OracleType.NVarChar);
                paras[6].Value = cbinf.Tags;
                paras[7] = new OracleParameter("OBJ_ID_parms", OracleType.Int32);
                paras[7].Direction = ParameterDirection.Output;
                SQLHelper.ExecuteScaler(InsertInfo_Obj, CommandType.StoredProcedure, paras);
                int i=Convert.ToInt32(paras[7].Value);
                return i;

标签：

C# 获取 oracle 存储过程的 返回值

人气教程排行

C# 获取 oracle 存储过程的返回值