You might not have a public synonym for dbms_system.
Try
execute SYS.dbms_system.set_sql_trace_in_session (:sid, :serial#, true)
> -----Original Message-----
> From: Bob Metelsky [mailto:bmetelsky_at_CPS92.COM]
>
> All Im trying to run the following statement
>
> EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)
>
> And get the following error
>
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be
> declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> Looking under SYS schema I have package and package body for
> DBMS_SYSTEM
> and the body includes
> SET_SQL_TRACE_IN_SESSION
>
> I had to turn on tracing on the database level...
> What could be the matter with this??
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Oct 03 2002 - 14:10:07 CDT
