oracle - ORA-04063: 包体 "WB_PROD.PLOG"有错误

Question

我用oracle后端开发asp.net站点
我将数据从 .dmp 文件导入到本地数据库并从 Web 应用程序连接到数据库。

当我运行应用程序时，我收到以下错误

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

请让我知道如何解决这个问题......

谢谢

Answer 1

模式 WB_PROD 中的包体 PLOG 显然不存在或无法编译。您可以尝试编译它。以 WB_PROD 用户身份连接到数据库并发出命令

SQL> alter package body plog compile;

如有错误，

SQL> show errors