PL/SQL Á¬½ÓOracle£¬N¾ÃûÁ¬ÉÏ£¡¾È¼±
±¾ÈË×°µÄÊÇplsql7.0£¬»úÆ÷ÉÏûÓа²×°Oracle¿Í»§¶Ë£¬ÊDzÉÈ¡ÍøÉÏÄÇÖÖ¼òÒ×°²×°À´°²×°µÄ£¬
¿ªÊ¼Ö®³õÊÇ¿ÉÒÔÁ¬ÉÏOracleÊý¾Ý¿â·þÎñÆ÷£¬¿ÉÊÇijÌìÖØÐ°²×°ÁËÒ»´ÎOracle¿Í»§¶Ë£¬ÇÒ°ÑOracle¿Í»§¶Ëɾ³ýºó£¬
ÔÙÀûÓÃÍøÉϵÄÂÌÉ«Á¬½ÓOracle·½·¨£¬¾Í²»¿ÉÐÐÁË
´óÅ£ÃÇ£¬¾È¾È¼±°¡°¡°¡°¡°¡£¡£¡
ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ·
plsqlÖÐÓиöÑ¡ÏÉèÖóÉoracleName¾Í¿ÉÒÔÁË
up
ÓÐʲôÌáʾ£¬Ìù³öÀ´¿´Ò»Ï¡£
ÎÒµÄtnsnames.oraÎļþÈçÏ£º
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.(SERVER = DEDICATED)
# Çë¸ù¾Ýʵ¼ÊÇé¿öÔÚ±¾ÎļþÖÐÔö¼ÓÏàÓ¦µÄÁ¬½Ó²ÎÊý
DDDD_X.X.X.X =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DDDD_192.168.242.26)
)
)
²é¿´²¢È·ÈÏÄãµÄʵÀýÃûÊÇ·ñÊÇDDDD_192.168.242.26 ¸öÈ˾õµÃ×îºÃ±ðÓÃ.
¼ì²éÁ¬½ÓÊÇ·ñÕýÈ·
ÔÚPLSQL DeveloperÖÐÑ¡Ôñ ¹¤¾ß-Ê×Ñ¡Ïî£Á¬½Ó,ÒÔÏÂÁ½ÏîÐèÕýÈ·ÅäÖÃ
Oracle Ö÷Ŀ¼Ãû
OCI¿â
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......