db.AddOutParameter(dbCommand, "num1", DbType.Int32, 32); db.AddOutParameter(dbCommand, "num2", DbType.Int32, 50); db.ExecuteNonQuery(dbCommand); int num1 = int.Parse( db.GetParameterValue(dbCommand, "num1").ToString()); int num2 = int.Parse(db.GetParameterValue(dbCommand, "num2").ToString());
返回表(游标)的话,
cur_out 微软默认的
OracleParameter oraCur = new OracleParameter("cur_out", OracleType.Cursor); oraCur.Direction = ParameterDirection.Output; dbCommand.Parameters.Add(oraCur);
DataSet dbset=db.ExecuteDataSet(dbCommand);
一个db.ExecuteXXX 就可以用了。