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

[<log...@li...>]

=20

Bernhard,=20

=20

Please see: in OTN Note:272557.1

=20

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 wa=
s

able to execute this code without any errors.=20


1.1.1          Cause


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


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;

=20

Guillaume

  _____ =20

De : log...@li...
[mailto:log...@li...]=20
Envoy=E9 : lundi 6 d=E9cembre 2004 15:38
=C0 : log...@li...
Objet : [log4plsql] After installing I can=B4t compile plog package body

=20

There=B4s a error: PLS-00201 SYS.DBMS_SYSTEM Bezeichner muss deklariert wer=
den

=20

Any advice ?

=20


=20

=20


=20

=20