oracle ORA-04063: 包体“WB_PROD.PLOG”有错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6514501/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ORA-04063: package body "WB_PROD.PLOG" has errors
提问by praveenb
I developing asp.net site with oracle back end I imported data from .dmp file to local db and connected to the db from the web application.
我使用 oracle 后端开发 asp.net 站点我将数据从 .dmp 文件导入到本地数据库并从 Web 应用程序连接到数据库。
When i run the application im getting following error
当我运行应用程序时，我收到以下错误
ORA-04063: package body "WB_PROD.PLOG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "WB_PROD.PLOG"
ORA-06512: at "WB_PROD.WB_PCK_LOG", line 85
ORA-06512: at "WB_PROD.WB_PCK_USERS", line 133
ORA-04063: package body "WB_PROD.PLOG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "WB_PROD.PLOG"
ORA-06512: at line 1
Please let me know how to solve this issue....
请让我知道如何解决这个问题......
Thanks
谢谢
采纳答案by praveenb
I solved issues by seeing errors as Justin Cave said. For any one who have the same issue, i run following scripts to solve issue
正如 Justin Cave 所说，我通过查看错误来解决问题。对于任何有同样问题的人，我运行以下脚本来解决问题
SQL> connect / as sysdba
Connected.
SQL> grant execute on dbms_pipe to wb_prod;
Grant succeeded.
SQL> grant execute on sys.dbms_system to wb_prod;
Grant succeeded.
Which solved problem.
哪个解决了问题。
回答by Justin Cave
The package body PLOG in the schema WB_PROD apparently does not exist or does not compile. You can try to compile it. Connect to the database as the WB_PROD user and issue the command
模式 WB_PROD 中的包体 PLOG 显然不存在或无法编译。您可以尝试编译它。以 WB_PROD 用户身份连接到数据库并发出命令
SQL> alter package body plog compile;
If there are errors,
如有错误，
SQL> show errors
回答by dklovedoctor
There is a syntax error mentioned in the answer above.
上面的答案中提到了一个语法错误。
In 11g2you have to write:
在11g2你必须写：
SQL> alter package plog compile body;
If there are errors:
如果有错误：
SQL> show errors;
