asp.netÖ´ÐÐoracleµÄ´æ´¢¹ý³ÌÎÊÌ⣡

ÎÒÓÃodbcÁ¬½ÓÊý¾Ý¿â£¬
´æ´¢¹ý³ÌÒ²¶¼Ð´ºÃÁË£¡plsqlÖ´ÐÐûÎÊÌ⣡
ÓÃasp.netÖ´Ðоͳö´íÁË£¡
˵ÎÞЧsqlÓï¾ä£¡
ÇëÎÊÊÇÔõô»ØÊ£¿
»òÕßË­ÓÐÀý×Ó£¡¸ø·¢Ò»¸ö£¡²Î¿¼²Î¿¼£¡

---

ERROR [42000] [Oracle][ODBC][Ora]ORA-00900: ÎÞЧ SQL Óï¾ä

---

ÄãÈ·ÐÅASP.NET ÒѾ­Á¬ÉÏÁËORACLE?

---

public void ccgc(string Cname, string is_time)
  {
  try
  {

  OdbcCommand ocom = new OdbcCommand();
  ocom.CommandText = Cname;
  ocom.CommandType = CommandType.StoredProcedure;
  ocom.Connection = DBlink();

  OdbcParameter op = new OdbcParameter("is_time", OdbcType.VarChar, 100);
  op.Value = is_time;
  ocom.Parameters.Add(op);
  ocom.Parameters["is_time"].Direction = ParameterDirection.Input;

   
  ocom.ExecuteNonQuery();

  }
  catch (OdbcException ee)
  {
  throw new Exception(ee.Message);
  }
  finally { oc.Dispose(); }
  }


Õâ¸öÊÇÄãµÄ´úÂ룿£¿£¿

---

¸øÄãÒ»¸ö²Î¿¼£º
http://m.cnblogs.com/44564/1299037.html

---

DataSet ds= new DataSet();
using(OracleConnection conn = new OracleConnection(""))
{
OracleCommand cmd = n