Re: HELP!! can NOT use package "dbms_system.set_sql_trace_in_session

MCC wrote:
>
> We have Oracle 7.2.3 installed on SUN Sparc computer (SOLARIS 2.5). I tried to
> turn on/off sql_trace for a particular user use "exec dbms _..." it is not
> successful. The command I used is:
>
> SQL> execute dbms_system.set_sql_trace_in_session(10, 1111, TRUE);
>
> and I got following error message:
>
> PLS-00201: Identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be
> declared.
>
> Can anyone tell me how to fix it? Do I need run any utility SQL before I
> use "dbms_system...."? Thank you for help.

Ensure that you have installed DBMS_SYSTEM package. This package is supplied by ORACLE. U should find this in $ORACLE_HOME/rdbms/admin . Install this package as user SYS.

-- 

Regards,

Varad Acharya

 The above statements and opinions are my own and do not
 necessarily represent those of Ford Motor Company.