OracleParameterCollection 只接受非空的 OracleParameter 类型对象,不接受 OracleParameter 对象。
第一次调用Oracle11G的存储过程
代码:
DbCommand dbcmd = db.GetStoredProcCommand("getinstockbillanddetails"); //添加参数 db.AddInParameter(dbcmd, "instockid", DbType.Int32, int.Parse(stockId)); db.AddInParameter(dbcmd, "primaryname", DbType.String, "asdas"); db.AddInParameter(dbcmd, "attachname", DbType.String, "asdas"); OracleParameter oraPara1 = new OracleParameter("cur1", OracleDbType.RefCursor, ParameterDirection.Output); OracleParameter oraPara2 = new OracleParameter("cur2", OracleDbType.RefCursor, ParameterDirection.Output); //添加参数到cmd dbcmd.Parameters.Add(oraPara1); dbcmd.Parameters.Add(oraPara2); DataSet ds = db.ExecuteDataSet(dbcmd);