Re: HELP!! can NOT use package "dbms_system.set_sql_trace_in_session
From: Joseph Testa <jtesta_at_freenet.columbus.oh.us>
Date: 1996/11/15
Message-ID: <56hrju$6ft_at_login.freenet.columbus.oh.us>#1/1
: >
: > 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.
<snip>
Date: 1996/11/15
Message-ID: <56hrju$6ft_at_login.freenet.columbus.oh.us>#1/1
varad acharya (vacharya.ford_at_e-mail.com) wrote:
: 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.
<snip>
by default only sys has execute on that package, you must grant execute on it to the appropriate user. read the dbmsutil.sql in $ORACLE_HOME/rdbms/admin and you'll see the docs concerning it.
joe
-- Joseph S. Testa, Database Administrator, Ohio EPA N8XCT, Emergency Coordinator (EC) & Local Govt Liaison (LGL) Pickaway County, OH and Official Relay Station (ORS), message content are MY views and NOT my current employer.Received on Fri Nov 15 1996 - 00:00:00 CET