Re: DBMS_SYSTEM.Set_Sql_Trace_In_Session

First, has dbmsutil.sql script been executed (as SYS)?

If so, this script that creates the dbms_system package does not grant execute on it to public: only users with "execute any procedure" privilege can execute it. You have to explicitly grant the execute privilege on this package to the other users.

--
Have a nice day
Michel

Christophe Galerne <christophe_at_tumbleweed.com> a écrit dans le message : 384453F9.4E27F742_at_tumbleweed.com...
> Guys,
>
> for some reasons I can't use the command:
> dbms_system.Set_Sql_Trace_In_Session(...);
>
> I get those errors messages:
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> However I can use any other packages, like dbms_output, etc...
>
> Thanks,
> Christophe
Received on Wed Dec 01 1999 - 02:47:53 CST