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

oracleÖÐÌí¼ÓºÍɾ³ýÊý¾Ýʱ³ö´í - Oracle / »ù´¡ºÍ¹ÜÀí

1.Ìí¼Óʱ³ö´í:
  ´´½¨Ò»¸öÁÙʱ±í£¬²åÈë1000wÌõ¼Ç¼ʱ£¬±¨´í£ºora-30009: connect by ²Ù×÷ÄÚ´æ²»×ã
  ¸Ä³ÉÖ»²åÈë500wÐÐʱ¾Íû´íÁË¡£
   
  ¹ÊÇó¸ßÊÖÃǰïæ ½â¾öora-30009: connect by ²Ù×÷ÄÚ´æ²»×ãµÄÎÊÌâ

2.ɾ³ýÊý¾Ýʱ±¨´í:
  ÔÚʹÓÃforall...delete...ÅúÁ¿É¾³ýʱ³ö´í
  ´íÎó´úÂëÈçÏÂ:
  SQL code:

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: ÔÚ "SYS.DBMS_OUTPUT", line 32
ORA-06512: ÔÚ "SYS.DBMS_OUTPUT", line 97
ORA-06512: ÔÚ "SYS.DBMS_OUTPUT", line 112
ORA-06512: ÔÚ line 15



  Ï£Íû´ó¼Ò°ïæ½â¾öÒÔÉÏÁ½¸öÎÊÌ⣬²»Éõ¸Ð¼¤£¡


 
ÄÚ´æÏÞÖÆÁË£¬Çë¼ì²é

½«outputµÄbuffer size µ÷´ó

ÒýÓÃ
ÄÚ´æÏÞÖÆÁË£¬Çë¼ì²é

  ÔõÑù½â¾ö°¡£¡ À´¸ö¸ßÊÖ£¡

2.ɾ³ýÊý¾Ýʱ±¨´í:
  ÔÚʹÓÃforall...delete...ÅúÁ¿É¾³ýʱ³ö´í
  ´íÎó´úÂëÈçÏÂ:
----------------------------------
DBMS_OUTPUT.ENABLE(1000000); -- ¼Óµ½×ã¹»´óΪֹ

ÎÒ¾õµÃÄ㻹ÊÇ·ÖÅúÌύһϰÉ

»¥Ïàѧϰ
SQL> exec dbms_output.enable(100000);

PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
ÊÔÊÔ¿´

ora-30009: connect by ²Ù×÷ÄÚ´æ²»×ã
  Õâ¸öÎÊÌâÔõÑù½â¾öÄØ£¿

ÏÖÔÚ»¹Ã»Óöµ½¹ýÕâÑùµÄÎÊÌâ
ÏȼÇÏ¡£

½â¾ö


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

Oracle ¸ßÊÖ½ø - Java / Java EE

SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21
SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ