Hi Everyone,
My DB version is
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
I'm getting this error continuously even after granting the execution privilege to public and scott schema. How can I get rid of this error?? Please suggest.
Error starting at line 9 in command:
BEGIN
DBMS_ERRLOG.create_error_log (dml_table_name => 'Error_log_tbl');
END;
Error report:
ORA-04067: not executed, package body "SCOTT.DBMS_ERRLOG" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "SCOTT.DBMS_ERRLOG"
ORA-06512: at line 2
04067. 00000 - "not executed, %s does not exist"
*Cause: Attempt to execute a non-existent stored procedure.
*Action: Make sure that a correct name is given.
Regards,
BS2012.