Jcen <hang_at_programmer.net> wrote in article
<341b7e7f.9577115_at_news.singnet.com.sg>...
> 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;
> >/
> >
>
Make sure the owner of the package, SYS, granted EXECUTE to PUBLIC. Then
the stored procedure should compile OK. Also create a public synonym for
the package.
- Dan Clamage dclamage AT idcomm DOT com
Received on Wed Sep 17 1997 - 00:00:00 CDT
