Re: set trace for a session

From: Peter Dickmann <pdickmann_at_de.lhsgroup.com>
Date: 2000/05/26
Message-ID: <392e6110_at_news.lhsgroup.com>#1/1

Oracle8 manual:

DBMS_ORACLE_TRACE_AGENT.SET_ORACLE_TRACE_IN_SESSION

   sid                NUMBER   DEFAULT 0,
   serial#            NUMBER   DEFAULT 0,
   on_off IN          BOOLEAN  DEFAULT false,

   collection_name IN VARCHAR2 DEFAULT '',    facility_name IN VARCHAR2 DEFAULT '');

Peter

Gary Knopp <gknopp_at_ascend.com> wrote in message news:8gh2nv$n06_at_nntpb.cb.lucent.com...
>
> Hello,
> I get a declaration error when I try to use a session trace
> procedure in the dbms_system package.
> What do I need to do to fix this?
>
> execute dbms_system.set_sql_trace_in_session(12,12,TRUE);
>
>
> ORA-06550: line 2, column 2:
> PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be
> declared
> ORA-06550: line 2, column 2:
> PL/SQL: Statement ignored
>
>
>
>
>
Received on Fri May 26 2000 - 00:00:00 CEST