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
Ïà¹ØÎÊ´ð£º
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......
ÎÒÏëʵÏÖÒ»¸öЧ¹ûÊÇ£ºÄܰÑÒ³Ãæ·Ö³É¼¸¸ö´ó¿é£¬µãÏ´ó¿éÉϵÄ+±ãÕ¹¿ª£¬µãÏÂ-±ãÕÛµþ¡£
Õâ¸öÓÐʲô¿Ø¼þ¿ÉÒÔÓò»£¬Çë¸ßÊÖ²»Áߴͽ̣¡
ÓÃjs´úÂëÀ´ ¿ØÖÆ divµÄ¶¯×÷´Ó¶øÄÜʵÏÖ
js¿ØÖÆdivÏÔʾ/Òþ²ØÁË
VS2008×Ô´ø·â×°Á ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£
ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......