Re: calling a stored procedure from a stored procedure

RU wrote:
> Hi Folks,
>
> I'm trying to define a (I thought) trivial stored procedure (SP) as
> a front-end to the standard SP "dbms_system.set_ev",
> which I want to use to generate a 10046 tracing event. I'm trying
> to execute the following PL/SQL:
>
> create or replace procedure rob_enable_tracing (
> sid in integer,
> serial in integer
> )
> is
> begin
> dbms_system.set_ev(sid, serial, 10046, 4, '');
> end;
>
> and getting the error:
>
> PLS-00201: identifier 'DBMS_SYSTEM.SET_EV' must be declared
>
> If I provide the schema in which "set_ev" is defined, in this case "SYS",
> as in:
>
> create or replace procedure rob_enable_tracing (
> sid in integer,
> serial in integer
> )
> is
> begin
> sys.dbms_system.set_ev(sid, serial, 10046, 4, '');
> end;
>
> I get:
>
> PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared
>
>
> Any suggestions?
>
> thanks,
>
> RU

You don't have explicit permissions granted to execute the package.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org