Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

AspxÓëoracleÖ®¼äµÄÁ¬½ÓÎÊÌâ

¸÷λ¸ßÊÖ¡£¡£±¾ÈËÓöµ½Ò»¸öÎÊÌ⣬·Ç³£µÄ¹ÖÒ죺
    ÎÒ¿ª·¢ÁËÒ»¸ö¾ºÅĵÄÍøÕ¾¡£ÔÚvs2005 ÉϲâÊÔÍêȫûÓÐÎÊÌâ¡£µ«ÊÇ·¢²¼³öÀ´µÄ´úÂëÔÚiis Öеķ¢²¼Ëý±¨³öÁËÊý¾Ý¿âÁ¬½Óʧ°Ü£¿
    µ«ÊÇÎÒÕâÌ×Êý¾Ý¿âÁ¬½Ó£¬ÎÒÒÔǰÓùýÍêȫûÓÐÎÊÌâ°¡£¿£¿
    ¸÷λ´ó¸çÖ¸µãÒ»ÏÂСµÜ£º

    Êý¾Ý¿âÁ¬½Ó·û£ºData Source=Data;Persist Security Info=True;User ID=outln;Password=123;Unicode=True
    ´úÂë:
C# code:

OracleConnection Conn = GetSqlConnection("Á¬½Ó·û");
string CommTxt="sql Óï¾ä";
cmd.CommandText = CommTxt;
OracleCommand cmd = new OracleCommand();
cmd.Connection = Conn;
Conn.Open();--------------------¡·¡·¾ÍÊÇÔÚ´ò¿ªÁ¬½ÓµÄʱºò³ö´íµÄ
OracleTransaction Tran = Conn.BeginTransaction();
cmd.Transaction = Tran;
try
{
rInt = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
catch (Exception ex)
{
}


ûÓÐÈËÖªµÀÂ𣿣¿¸÷λ¸øµãÌáʾ£¡£¡

˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£

Òì³£ÏêϸÐÅÏ¢: System.Exception: OCIEnvCreate ʧ°Ü£¬·µ»Ø´úÂëΪ -1£¬µ«´íÎóÏûÏ¢Îı¾²»¿ÉÓá£

Ô´´íÎó:


ÐÐ 2685:                sb.AppendFormat("SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from {0} {1} {2}) A WHERE ROWN


Ïà¹ØÎÊ´ð£º

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

eclipseÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ