From: YourNameHere <yname@uk.oracle.com>
Subject: Re: DBMS_PIPE question
Date: 1996/08/08
Message-ID: <3209E736.6F76@uk.oracle.com>#1/1
references: <4ubd0c$63d@nntp1.best.com>
content-type: text/plain; charset=us-ascii
organization: Oracle Corporation UK Limited
mime-version: 1.0
newsgroups: comp.databases.oracle
x-mailer: Mozilla 2.02 (Win95; I; 16bit)



Todd Hansen wrote:
> 
> Hi All:
> 
> I've run into a curious error while putting together a PL/SQL package that
> has a call to DBMS_PIPE
> 
> The code piece is as follows:
> 
> dbms_pipe.pack_message(nExceptionId);
> ret_stat := dbms_pipe.send_message('ireg_daemon');
> 
> And I receive the following errors for these two lines:
> 
> LINE/COL ERROR
> -------- -----------------------------------------------------------------
> 37/3     PLS-00201: identifier 'SYS.DBMS_PIPE' must be declared
> 37/3     PL/SQL: Statement ignored
> 38/3     PL/SQL: Statement ignored
> 38/15    PLS-00201: identifier 'SYS.DBMS_PIPE' must be declared
> 
> I'll confess to being new to the use of pipes, and that I must have missed
> something, but I can't deduce what exactly is amissbased on the book I'm
> using (Oracle7 Server Application Developer's Guide Release 7.2).
> 
> Any help will be greatly appreciated.
> 
> Thanks
> 
> Todd C. Hansen
> 
> --
> *******************************************************************************
> * Todd Hansen                   * Lt. Scotty vestai-MacKlingon                *
> * gaheris@best.com              * CO IKV Kahlua Klingon Assault Group         *
> * http://www.best.com/~gaheris  * http://www.best.com/~gaheris/MidnightDagger *
> * My other surfboard's a caber! * yu'egh'a'na'                                *
> *******************************************************************************

Have you run $ORACLE_HOME/rdbms/admin/catproc.sql ?