Help: PL/SQL Compile ERROR

Hello all,

I'm having a problem compiling a PL/SQL package. I have supplied the code and error results below. I would appreciate it if some kind sole would help save my sanity and shed some light to what might be going here.

I have defined the following package ...

create or replace package daemon as

    function execute_system(command varchar2, timeout number default 10)

         return number;
    function execute_sql(command varchar2, timeout number default 10)

         return number;
    procedure stop(timeout number default 10); end daemon;
/

this compiled with now error - now I try to compile the foloowing body...

01 create or replace package body daemon as 02 function execute_system( command varchar2, timeout number default 10) return number is

03         s number;
04         result varchar2(20);
05         command_code number;
06         pipe_name varchar2(30);
07   begin
08       pipe_name := dbms_pipe.unique_session_name;
09       dbms_pipe.pack_message('SYSTEM');
10       dbms_pipe.pack_message(pipe_name);
11       dbms_pipe.pack_message(command);

and I get the errors as follows...

Errors for PACKAGE BODY DAEMON:

LINE/COL ERROR

-------- -----------------------------------------------------
8/7      PL/SQL: Statement ignored
8/20     PLS-00201: identifier 'DBMS_PIPE' must be declared
9/7      PLS-00201: identifier 'DBMS_PIPE' must be declared
9/7      PL/SQL: Statement ignored
10/7     PLS-00201: identifier 'DBMS_PIPE' must be declared
10/7     PL/SQL: Statement ignored
11/7     PLS-00201: identifier 'DBMS_PIPE' must be declared
11/7     PL/SQL: Statement ignored

.... etc......

Can anyone shed some light on this for me??????

-Tim Smith Received on Sun Feb 05 1995 - 15:20:16 CET