Re: DBMS_PIPE question

gaheris_at_nntp.best.com (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' *
>*******************************************************************************

It may be as simple as connect to the database as user SYSTEM and issuing a GRANT EXECUTE ON DBMS_PIPE TO PUBLIC;

//Dave Macpherson Received on Fri Aug 09 1996 - 00:00:00 CEST