Oracle – ORA-04063: package body “WB_PROD.PLOG” has errors

ora-04063oracleplsql

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.

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

Best Solution

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

SQL> alter package body plog compile;

If there are errors,

SQL> show errors
Related Question