asp.net·¢²¼Ê±£¬Oracle±¨´í - .NET¼¼Êõ / ASP.NET
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊÊý¾Ý¿âÕý³££¬µ«debugºó£¬Òì³£¡£
4.ʹÓÃÊý¾Ý¿â·ÃÎÊÀà¡°IDbConnection¡±¡¢OracleClient
ÍøÕ¾·¢²¼³öÀ´ºó£¬Ö÷Ò³ÄܵǼ£¬µ«ÊÇÊý¾Ý¿â·ÃÎʲ»ÁË£¬Ìáʾ´íÎ󡣸ù¾ÝÍøÉϴ𰸣¬½øÐÐÐ޸ģ¬·Ö±ð³öÏÖ¹ýһϴíÎó£º
1£©"ORA-12154: TNS: ÎÞ·¨´¦Àí·þÎñÃû"
2£©"System.Data.OracleClient ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1.7 »ò¸ü¸ß°æ±¾"
3£©...
¶÷ ºÃµÄ лл ±È½Ï¼± ÔÚÏßµÈ
ºÜÆæ¹Ö web·þÎñÆ÷ÉϱߵÄnetmanager¸ù±¾µã²»¿ª
×¢£ºÖ®Ç°ÎÒ°²×°¹ý9iµÄ¿Í»§¶Ë£¬ÔÚ¿ØÖÆ̨°ÑËûɾÁË£¬Ö®ºó²Å°²×°µÄ10g¿Í»§¶Ë
×¢Ò⣺web·þÎñÆ÷ÊÇ64λµÄserver2003 ²»ÖªµÀÕâ¸öÓÐûÓÐÓ°Ï죬ÒÔÇ°µÄ ¶¼ÊÇ32λµÄserver2003
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£
ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡
¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡
Ö±½ÓÖ´ÐоÍÐÐÁË
exec ......