如何调用ORACLE存储过程，请各位高手指教！

如何在c#中调用ORACLE存储过程，请各位高手指教！ 问题点数：20、回复次数：1Top

1 楼jiezhi（风满袖）回复于 2003-04-13 19:00:34 得分 20

SqlConnection   connOCC   =   new   SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);  
  SqlCommand   cmdOCC   =   new   SqlCommand("OCC_AddRequest",   connOCC);  
  cmdOCC.CommandType   =   CommandType.StoredProcedure;  
   
  SqlParameter   prmSSN   =   new   SqlParameter("@SSN",   SqlDbType.VarChar,   12);  
  prmSSN.Direction   =   ParameterDirection.Input;  
  cmdOCC.Parameters.Add(prmSSN);  
  prmSSN.Value   =   ssn;  
   
  SqlParameter   prmRepID   =   new   SqlParameter("@RepID",   SqlDbType.VarChar,   6);  
  prmRepID.Direction   =   ParameterDirection.Input;  
  cmdOCC.Parameters.Add(prmRepID);  
  prmRepID.Value   =   repID;  
   
  //以下是返回值参数  
  SqlParameter   prmReturnValue   =   new   SqlParameter("@ReturnValue",   SqlDbType.Int);  
  prmReturnValue.Direction   =   ParameterDirection.ReturnValue;  
  cmdOCC.Parameters.Add(prmReturnValue);  
  prmReturnValue.Value   =   0;  
   
  connOCC.Open();  
  cmdOCC.ExecuteNonQuery();  
  int   rValue   =   System.Convert.ToInt32(prmReturnValue.Value);  
  connOCC.Close();  
   
  string   strMessage;  
  int   ID;  
  if   (rValue==0)  
  {  
  ID   =   0;  
  strMessage   =   "A   Request   have   been   added   successfully.";  
  }  
  else  
  {  
  ID   =   8;  
  strMessage   =   "A   record   with   the   same   SSN   and   RepID   already   exists.   Request   ignored.";  
  }  
  Top

相关问题

• cmdocc
• prmreturnvalue
• connocc
• prmssn
• prmrepid
• repid
• sqlparameter
• strmessage
• parameterdirection
• ssn

• 帖主：wj1280
• jiezhi

• CSDN .NET频道
• .NET类图书
• C#类图书
• .NET类源码下载