RE: [log4plsql] After installing I can?t compile plog package body

Mon, 06 Dec 2004 08:51:02 -0800

Title: Allgäuer Zeitungsverlag GmbH EDV Abteilung  Heisinger Straße 14  D

 

Bernhard,

 

Please see: in OTN Note:272557.1

 

Oracle 9i when you execute the following statements:

begin
sys.dbms_system.set_sql_trace_in_session(. . .);
end;

You get the following errors:

ORA-06550: line 2, column 2:
PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
USER is "SYSTEM"

Even though the user which is executing the package has the DBA and SYSDBA roles.
This was not the behavior is Oracle8i since user with DBA or SYSDBA role was
able to execute this code without any errors.

1.1.1          Cause

In 9.2 for security reasons dbsm_system is protected, so you need to grant execute privileges
explicitly. This is the expected behavior in 9.2.

1.1.2          Fix

Grant the execute privileges to the user explicitly via a grant execute statement.
E.g.,
grant execute on sys.dbms_system to scott;

 

Guillaume

De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoyé : lundi 6 décembre 2004 15:38
À : [EMAIL PROTECTED]
Objet : [log4plsql] After installing I can´t compile plog package body

 

There´s a error: PLS-00201 SYS.DBMS_SYSTEM Bezeichner muss deklariert werden

 

Any advice ?

 

 

 

 

 

Reply via email to