asp.net中调用oracle存储过程的方法

CREATE OR replaCE PROCEDURE gd_cursOR(MYCS1 OUT SYS_REFcursOR,MYCS2 OUT SYS_REFcursOR,a out varchar)as
BEGIN
 a:='test';
 OPEN MYCS1 FOR
 SELECT 1 from dual;
 OPEN MYCS2 FOR
 SELECT 2 from dual;

END;

 /// <sumMary>
 /// 执行Oracle存储过程返回多个结果集
 /// </sumMary>
 /// <param name="strProcName">存储过程名称</param>
 /// <param name="ResultCount">返回个数</param>
 /// <param name="paras">参数</param>
 /// <returns>任意对象数组</returns>
 public object[] ExcuteProc_N_Result(String strProcName,int ResultCount,params OracleParameter[] paras)
 {
  using (OracleConnection conn = new OracleConnection("User ID=用户名;password=密码;Data source=数据库;"))
  {
  OracleCommand cmd = new OracleCommand(strProcName,conn);
  if (paras != null && paras.Length > 0)
  {
   for (int j = 0; j < paras.Length; j++)
   {
   if (paras[j].Value == null)
   {
    paras[j].Value = dbnull.Value;
   }
   }
  }
  cmd.Parameters.AddRange(paras);
  cmd.Commandtype = commandType.StoredProcedure;
  conn.open();
  cmd.ExecuteNonQuery();
  int i = 0;
  //int nOutputParametersCount = 0;
  object[] objResult = new object[ResultCount];
  foreach (OracleParameter p in cmd.Parameters)
  {
   if (p.Direction == ParameterDirection.output || p.Direction == ParameterDirection.InputOutput)
   {
   if (p.Value is OracleDataReader)
   {
    OracleDataReader reader = p.Value as OracleDataReader;
    objresult[i++] = ConvertDataReaderToDataTable(reader);
   }
   else
   {
    objresult[i++] = p.Value;
   }
   }
  }
  return objResult;
  }
 }
 /// <sumMary> 
 /// 将DataReader 转为 DataTable 
 /// </sumMary> 
 /// <param name="DataReader">OleDbDataReader</param> 
 protected DataTable ConvertDataReaderToDataTable(OracleDataReader reader)
 {
  DataTable objDataTable = new DataTable("TmPDAtaTable");
  try
  {
  int intFieldCount = reader.FieldCount;//获取当前行中的列数；
  for (int intCounter = 0; intCounter <= intFieldCount - 1; intCounter++)
  {
   objDataTable.columns.Add(reader.GetName(intCounter),reader.GetFieldType(intCounter));
  }
  //populate datatable 
  objDataTable.beginLoadData();
  //object[] objValues = new object[intFieldCount -1]; 
  object[] objValues = new object[intFieldCount];
  while (reader.Read())
  {
   reader.GetValues(objValues);
   objDataTable.LoadDaTarow(objValues,truE);
  }
  reader.Close();
  objDataTable.EndLoadData();
  return objDataTable;
  }
  catch (Exception eX)
  {
  throw new Exception("转换出错出错!",eX);
  }
 }

OracleParameter[] OracleParameter = new OracleParameter[]{
new OracleParameter("MYCS1",OracleType.cursor),new OracleParameter("MYCS2",new OracleParameter("a",OracleType.VarChar,200),};
OracleParameter[0].Direction = ParameterDirection.output;
OracleParameter[1].Direction = ParameterDirection.output;
OracleParameter[2].Direction = ParameterDirection.output;

object[] xxx = ExcuteProc_N_Result("gd_cursOR",3,OracleParameter);

Create or replace Procedure xx_yy
(
 i_OrderID in number,i_ReturnValue out number
)
is
 v_RealValue number;
 v_@R_764_10586@lValue number;
 v_Advendorid number;
begin
 自己写就行
end;

create table ORDERTABLE
(
 ORDERid number not null,TEXT numbER not null
)

(
 i_OrderID in number,i_ReturnValue out number
)
is
 spass ordertable.text%type;
begin
 SELEct text into spass from ordertable where orderid=i_OrderID; 
 i_ReturnValue:=spass;
 exception
 when no_data_found
 then i_ReturnValue:=-1; 
end;

using System.Data .OracleClient ;//(别忘了添加)
OracleConnection Oraclecon = new OracleConnection ("password=dloco;User ID=dloco;Data source=dloco;");
  OracleCommand myCMD = new OracleCommand();
  OracleParameter[] parameters = { new OracleParameter("i_OrderID",OracleType.number,10),new OracleParameter("i_ReturnValue",10 )};
  parameters[0].Value = 1;
  parameters[1].Direction = ParameterDirection.output;

  myCMD.Connection = Oraclecon;
  myCMD.Commandtype = commandType.StoredProcedure;
  myCMD.CommandText = "dloco.xx_yy";

  myCMD.Parameters .Add (parameters[0]);
  myCMD.Parameters .Add (parameters[1]);

  myCMD.Connection.open();  

  myCMD.ExecuteNonQuery();  
  
  String result=myCMD.Parameters["i_ReturnValue"].Value.ToString();
  messageBox.Show (result);

  Oraclecon.Close();