When a make a procedure
CREATE OR REPLACE PROCEDURE ERROR_LOG_TABLES
AS
BEGIN
DBMS_ERRLOG.CREATE_ERROR_LOG('dummy');
END ;
EXECUTE ERROR_LOG_TABLES();
its giving error :-
Error report -
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_ERRLOG", line 113
ORA-06512: at "SYS.DBMS_ERRLOG", line 107
ORA-06512: at "SYS.DBMS_ERRLOG", line 422
ORA-06512: at "SINGBOSS.ERROR_LOG_TABLES", line 4
ORA-06512: at line 1
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges
but when I call
EXECUTE DBMS_ERRLOG.CREATE_ERROR_LOG('dummy');
it is getting called successfully .
PL/SQL procedure successfully completed.