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
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......