Re: DBMS_PIPES

The DBMS_PIPE package has been giving me all sorts of problems (strangely enough not on all machines, though). Couple of things to try: 1) Run both scripts (dbmspipe.sql and prvtpipe.plb) again as sys 2) grant the user that needs to use the package the "execute any procedure" privilege (the weird thing about this is that even if I grant dba to my user, which includes "execute any procedure", I still have to grant this *explicitly* on some machines to get it to work)

Cheers, E.

Jcen <hang_at_programmer.net> wrote in article <341b7e7f.9577115_at_news.singnet.com.sg>...
> Hi,
>
> I am also having this problem.
> Anybody has any solution?
> It's from the example in the Manuals.
> Thanks.
>
>
>
> On Fri, 29 Aug 1997 15:42:31 -0400, "Claude A. Charles"
> <claude_charles_at_mail.amsinc.com> wrote:
> >I am working with DBMS_PIPES and I am running through a number of
> >problems. If I try to call the procedures in the DBMS_PIPE package in my
> >procedures I get this error message: PLS-00201: identifier
> >SYS.DBMS_PIPE' must be declared. But if I run the
> >SQL*Plus utility and I type the following code sample below on the
> >command line the execution is successful.
> >
> >BEGIN
> > DBMS_PIPE.PACK_MESSAGE('X')
> >END;
> >/
> >
>
>
Received on Mon Sep 15 1997 - 00:00:00 CDT