HELP!! can NOT use package "dbms_system.set_sql_trace_in_session
From: MCC <duffy_at_cais.cais.com>
Date: 1996/11/02
Message-ID: <55ft8q$pk6_at_news2.cais.com>#1/1
Date: 1996/11/02
Message-ID: <55ft8q$pk6_at_news2.cais.com>#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.
Can anyone tell me how to fix it? Do I need run any utility SQL before I use "dbms_system...."? Thank you for help. Received on Sat Nov 02 1996 - 00:00:00 CET