Re: Help: PL/SQL Compile ERROR

In <tcsmith.92.000F56F9_at_csi.nb.ca>, tcsmith_at_csi.nb.ca (Tim Smith) writes:
>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

It looks like you (or your dba) did not run the script that creates package dbms_pipe. The script I used is called dbmspipe.sql. You will have to be connected as user 'sys'.

M.Landa Received on Mon Feb 06 1995 - 20:04:29 CET