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

OracleÊý¾Ý¿âÁ¬½Ó²âÊÔÎÊÌâ - .NET¼¼Êõ / C#

¾Í¼òµ¥Ê¾ÒâÏÂÎÒдµÄ´úÂ룬µ«ÊÇÕâÑùÐèÒªÅäÖÃOracleÊý¾Ý¿â·þÎñµÈ£¨ÎҵijÌÐòĿǰûÓгɹ¦£©£¬¸Ð¾õʵ¼ÊÔËÓúÜÂé·³£¬²»¿ÉÐÐ
ÏñVisual StudioÖУ¬Ö±½ÓÁ¬½ÓÊý¾Ý¿â£¬É¶Ò²²»ÓÃÅäÖ㬾ÍÄܲâÊÔÕâ¸öÁ¬½ÓÓÐûÓÐÓÐЧ
public string CheckConnection(string ConnStr)
{
try
{
  OracleConnection OraConn = new OracleConnection(ConnStr);
  OraConn.Open();
  OraConn.Close();
  Message = "Á¬½Ó³É¹¦";
}
catch(System.Exception e)
{
  Message = "Á¬½Óʧ°Ü";

}
return Message;
}

ÏÖÔÚÎÒÏëÖªµÀµÄÊÇ£¬ÓÐûÓÐʲôÇÐʵÓÐЧµÄ·½·¨ÊµÏÖOracleÊý¾Ý¿âµÄÁ¬½Ó²âÊÔ£¬»òÕßVS×Ô´ø¿Ø¼þ
¸÷λ´ó¸ç°ïæ°¡¡£¡£¡£

Õâ¸öÓ¦¸ÃÊÇOracleµÄÎÊÌâ,´úÂëÎÒÈÏΪÊÇûÎÊÌâµÄ

¶÷£¬ÎÒÒ²¾õµÃÕâ¸ö˼·ʵÏÖÊý¾Ý¿âÁ¬½Ó£¬ÔÚ´úÂëÉÏûÎÊÌ⣬µ«ÊÇÏÖÔÚÎÒ¾õµÄ°Ñ»·¾³ÅäÖÃÆðÀ´Ì«Âé·³ÁË£¬ÕæÕýÔËÓõ½ÏÖʵÖв»Ì«¿ÉÐУ¬ÓÐûÓÐÆäËû·½Ê½¿ÉÒÔÁ¬½Óµ½OracleÊý¾Ý¿â

ÄãÊÇÒªÁ¬½ÓÊý¾Ý¿â »¹ÊDzâÊÔÁ¬½ÓÊý¾Ý¿â£¿

²âÊÔÁ¬½ÓÊý¾Ý¿â

ÓиöÎÊÌâ. ÄãΪʲô²»×Ô¼ºÔÚ pl/sql ÀïÃæÅäÔòÅäÖòâÊÔ£¿

ÄãÏÖÔÚËù×öµÄ²Ù×÷ÎÞ·ÇÊÇÏëÖ¤Ã÷ ÄãµÄ»úÆ÷Óëoracle·þÎñÆ÷ ÊÇ·ñÁ¬½ÓÉÏÁË
  ÄÇô pl/sql ÀïÃæµÄÅäÖùÜÀíÆ÷ ºÜÈÝÒ×ʵÏÖÕâ¸ö²Ù×÷ д´úÂë²âÊÔ Äã²»¾õµÃ¹ýÓÚÂé·³...

pl/sql¿ÉÒÔÁ¬µ½°¡£¬ÎÒÏÖÔÚÊÇ×öÒ»¸öÏîÄ¿£¬ÀïÃæÓиö¹¦ÄÜÐèÒª²âÊÔÓû§ÊäÈëµÄÊý¾Ý¿âÁ¬½ÓÐÅÏ¢ÊÇ·ñÓÐЧ£¬so¡£¡£¡£

Ŷ ÕâÑùµÄ°¡
 http://support.microsoft.com/kb/965022/zh-cn
  ¸øÄã²Î¿¼

˵ʵ»° ºÜ¶àÈ˶¼ÊDzÉÓõÚÈý·½¹¤¾ßÀ´ÊµÏÖÕâ¸ö ²»¹ýÄãÕâÏîÄ¿ÀïÃ


Ïà¹ØÎÊ´ð£º

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......

±éÀúÒ»¸öxml²¢Êä³öÖ¸¶¨½ÚµãµÄÖµ - .NET¼¼Êõ / C#

ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
  <RequestType>DISCOVER_XML_ME ......

javaÁ¬²»ÉÏoracle£¿ - Java / Java EE

java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......

Çë½ÌÒ»¸öoracle¹ÜÀíµÄÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí

·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ