Re: dbms_pipe error

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/08/03
Message-ID: <33ed1868.6199894_at_newshost>#1/1

You need to grant execute on dbms_pipe to the owner of this procedure. You might be able to 'desc' dbms_pipe in sql*plus but that doesn't mean you can create a stored object that relies on dbms_pipe. You must have direct access to an object in order to create a stored object that uses it.

to see if this is your problem try the following:

SQL> desc dbms_pipe.pack_message
SQL> set role none;
SQL> desc dbms_pipe.pack_message

If the first desc works and the second doesn't then you have access to dbms_pipe via a role, not directly, and will need to have execute granted to you.

On 2 Aug 1997 22:02:03 GMT, "Vidar Mikkelsen" <vmikkels_at_online.no> wrote:

>
>What is wrong with this sample procedure ??
>
>I use this release :
>Personal Oracle7 Release 7.2.2.3.1 - 90 day trial license
>PL/SQL Release 2.2.2.3.1 - Production
>(Win95)
>
>create or replace procedure test is
>
>stat integer ;
>xx varchar2(100);
>
>begin
> dbms_output.enable(10000);
>
> xx := 'test string';
>
> dbms_pipe.pack_message(xx);
> stat := dbms_pipe.send_message('testpipe');
>
> dbms_output.put_line(stat);
>
>end;
>/
>show errors;
>--------------------------------------------------
>LINE/COL ERROR
>-------- -----------------------------------------------------------------
>7/2 PLS-00201: identifier 'SYS.DBMS_PIPE' must be declared
>7/2 PL/SQL: Statement ignored
>8/2 PL/SQL: Statement ignored
>8/10 PLS-00201: identifier 'SYS.DBMS_PIPE' must be declared
>----------------------------------------------------------------------------
>
>
>Vidar.

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Aug 03 1997 - 00:00:00 CEST