Re: DBMS_PIPE question
Date: 1996/08/08
Message-ID: <4ubeik$dta_at_inet-nntp-gw-1.us.oracle.com>#1/1
In article <4ubd0c$63d_at_nntp1.best.com>, gaheris_at_nntp.best.com (Todd Hansen) writes:
|> 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.
You need to have execute permission on the DBMS_PIPE package. Connect as sys or system, and GRANT EXECUTE ON DBMS_PIPE TO <you>. This is assuming that the DBMS_PIPE package has been created - if not, then run $ORACLE_HOME/rdbms/admin/catproc.sql as sys or connected internal.
|>
|> 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' *
|> *******************************************************************************
|>
Scott Urman Oracle Corporation surman_at_us.oracle.com
Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm
"The opinions expressed here are my own, and are not necessarily that of Oracle Corporation"
Received on Thu Aug 08 1996 - 00:00:00 CEST