DBMS_PIPE question

From: Todd Hansen <gaheris_at_nntp.best.com>
Date: 1996/08/08
Message-ID: <4ubd0c$63d_at_nntp1.best.com>#1/1


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

Original text of this message