\u6d4b\u8bd5\u4e2d\u65e0\u610f\u53d1\u73b0\u4e86\u8fd9\u4e2abug\uff0c\u572811.2\u6570\u636e\u5e93\u901a\u8fc7\u6570\u636e\u5e93\u94fe\uff0c\u6267\u884c10.2.0.1\u4e0a\u7684\u8fc7\u7a0b\uff0c\u7ed3\u679c\u51fa\u73b0ORA-06553: PLS-801: internal error [55916]\u7684\u9519\u8bef\u3002
\n\u9519\u8bef\u53ef\u4ee5\u901a\u8fc7\u4e0b\u9762\u7684\u4f8b\u5b50\u91cd\u73b0\uff1a<\/p>\n
-bash-3.2$ sqlplus \/ as sysdba\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 12 23:12:47 2011\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\nConnected to:\r\nOracle Database 10g Express Edition Release 10.2.0.1.0 \u2013 Production\r\nSQL> create user test identified by test default tablespace users;\r\nUser created.\r\nSQL> show parameter service\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\nservice_names string XE\r\nSQL> grant connect, resource, dba to test;\r\nGrant succeeded.\r\nSQL> conn test\/test\r\nConnected.\r\nSQL> create procedure p1 as\r\n 2 begin\r\n 3 null;\r\n 4 end;\r\n 5 \/\r\nProcedure created.<\/pre>\n\u9996\u5148\u572810.2.0.1\u73af\u5883\u4e2d\u521b\u5efa\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u3002<\/p>\n
SQL> create database link xe connect to test identified by test using '192.168.0.20:1522\/XE';\r\nDatabase link created.\r\nSQL> exec p1@xe\r\nBEGIN p1@xe; END;\r\n*\r\nERROR at line 1:\r\nORA-04052: error occurred when looking up remote object TEST.P1@XE\r\nORA-00604: error occurred at recursive SQL level 1\r\nORA-06544: PL\/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []\r\nORA-06553: PLS-801: internal error [55916]\r\nORA-02063: preceding 2 lines from XE\r\nSQL> select * from dual@xe;\r\nD\r\n-\r\nX\r\nSQL> select * from v$version;\r\nBANNER\r\n--------------------------------------------------------------------------------\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production\r\nPL\/SQL Release 11.2.0.2.0 - Production\r\nCORE 11.2.0.2.0 Production\r\nTNS for Linux: Version 11.2.0.2.0 - Production\r\nNLSRTL Version 11.2.0.2.0 \u2013 Production\r\nSQL> select * from v$version@xe;\r\nBANNER\r\n----------------------------------------------------------------\r\nOracle Database 10g Express Edition Release 10.2.0.1.0 - Product\r\nPL\/SQL Release 10.2.0.1.0 - Production\r\nCORE 10.2.0.1.0 Production\r\nTNS for Linux: Version 10.2.0.1.0 - Production\r\nNLSRTL Version 10.2.0.1.0 - Production<\/pre>\n\u572811.2\u4e2d\u8c03\u7528\u8fd9\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u62a5\u9519\uff0c\u5c1d\u8bd5\u4f7f\u7528\u540c\u4e49\u8bcd\u6216\u52a8\u6001SQL\uff0c\u90fd\u65e0\u6cd5\u7ed5\u8fc7\u8fd9\u4e2a\u9519\u8bef\uff1a<\/p>\n
SQL> create synonym s1 for p1@xe;\r\nSynonym created.\r\nSQL> exec s1\r\nBEGIN s1; END;\r\n*\r\nERROR at line 1:\r\nORA-04052: error occurred when looking up remote object TEST.P1@XE\r\nORA-00604: error occurred at recursive SQL level 1\r\nORA-06544: PL\/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []\r\nORA-06553: PLS-801: internal error [55916]\r\nORA-02063: preceding 2 lines from XE\r\nSQL> begin\r\n 2 execute immediate 'begin p1@xe; end;';\r\n 3 end;\r\n 4 \/\r\nbegin\r\n*\r\nERROR at line 1:\r\nORA-04052: error occurred when looking up remote object TEST.P1@XE\r\nORA-00604: error occurred at recursive SQL level 2\r\nORA-06544: PL\/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []\r\nORA-06553: PLS-801: internal error [55916]\r\nORA-02063: preceding 2 lines from XE\r\nORA-06512: at line 2<\/pre>\n\u5728metalink\u6587\u6863Bug 4511371\u4e2d\u63cf\u8ff0\u4e86\u8fd9\u4e2a\u95ee\u9898\uff1aORA-6544 \/ ORA-4052 using PLSQL between 10g and 11g\u3002\u6839\u636e\u6587\u6863\u63cf\u8ff0\uff0c\u572810.2.0.1\u4e2d\u901a\u8fc7\u6570\u636e\u5e93\u94fe\u8bbf\u95ee11.2\u7684\u8fc7\u7a0b\u4e5f\u4f1a\u51fa\u73b0\u540c\u6837\u7684\u9519\u8bef\uff0c\u800c\u89e3\u51b3\u65b9\u6cd5\u9664\u4e86\u5347\u7ea7\u523010.2.0.2\u53ca\u4ee5\u4e0a\u7248\u672c\u5916\uff0c\u6ca1\u6709\u5176\u4ed6\u7684\u89e3\u51b3\u65b9\u6cd5\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6d4b\u8bd5\u4e2d\u65e0\u610f\u53d1\u73b0\u4e86\u8fd9\u4e2abug\uff0c\u572811.2\u6570\u636e\u5e93\u901a\u8fc7\u6570\u636e\u5e93\u94fe\uff0c\u6267\u884c10.2.0.1\u4e0a\u7684\u8fc7\u7a0b\uff0c\u7ed3\u679c\u51fa\u73b0ORA-06553: PLS-801: internal error [55916]\u7684\u9519\u8bef\u3002 \u9519\u8bef\u53ef\u4ee5\u901a\u8fc7\u4e0b\u9762\u7684\u4f8b\u5b50\u91cd\u73b0\uff1a -bash-3.2$ sqlplus \/ as sysdba SQL*Plus: Release 10.2.0.1.0 – Production on Mon Sep 12 23:12:47 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 \u2013 … Continue reading