Re: calling a stored procedure from a stored procedure

On May 10, 1:25 pm, RU <r..._at_vakuum.de> 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

Look up PLS-201 in the Google archives. Your question has been asked AND answered at least a million times before.

--
Sybrand Bakker
Senior Oracle DBA