calling a stored procedure from a stored procedure

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 Received on Thu May 10 2007 - 06:25:28 CDT