Re: missing DBMS_SYSTEM

James Williams wrote:
>
> begin DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(14,5329,TRUE); end;
>
> *
> 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
>
> What do I need to run to declare the above package?

Probably needs to be qualified... ie

exec SYS.DBMS_SYSTEM. blah blah

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse