Re: DBMS_PIPE question

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_at_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 ? Received on Thu Aug 08 1996 - 00:00:00 CEST