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


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

Original text of this message