¹òÇó C#.net ODBCÔÚOracleÊý¾Ý¿âÖд´½¨±í
¸÷λ´óÏÀ£¬Ð¡ÃÃÏëÓà C#.net ODBCÁ¬½Ó ÔÚOracleÊý¾Ý¿âÖд´½¨±í£¬Çë´ó¼Ò°ïæһÏÂÌØ¼±£¡£¡
ÁíÍâÎÒÓÐдÁË´úÂë¿É×ÜÊDZ¨´í,´ó¼Ò°ïÎÒ¿´Ò»Ï£¡create±íµÄÓï¾äÔÚoracleµÄ¹¤¾ßÖÐÖ´ÐпÉÒÔ£¬µ«ÊÇÔÚÏÂÃæµÄ´úÂëÖÐÖ´Ðб¨
¡±[Microsoft][ODBC driver for Oracle][Oracle]ORA-00955: Ãû³ÆÒÑÓÉÏÖÓжÔÏóʹÓᰵĴíÎó
ÎÒÓõÄÊÇDNSÁ¬½ÓÊý¾Ý¿â
public bool ChkTable(string TableName) //¼ì²é±íÊÇ·ñ´æÔÚ
{
string sql = "";
OdbcConnection OdbcConn = new OdbcConnection(sConn);
OdbcCommand cmd = new OdbcCommand("", OdbcConn);
try
{
OdbcConn.Open();
sql = "SELECT COUNT(TABLE_NAME) * from USER_TABLES";
sql += " WHERE TABLE_NAME='" + TableName.ToUpper() + "' ";
cmd.CommandText = sql;
oResult= cmd.ExecuteNonQuery();
}
catch
&
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½ÔÒò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º
private void SendMail ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
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 / ......