Re: DBMS Pipes - redux

>Path: lcpd2!ncr-sd!ncrhub2!nntpa!gw1.att.com!csn!magnus.acs.ohio-state.edu!
math.ohio-state .edu!cs.utexas.edu!convex!news.duke.edu!news-feed-1.peachnet. edu!news
>From: John Morgan <John_Morgan_at_OIT.PeachNet.EDU>
>Newsgroups: comp.databases.oracle
>Subject: DBMS Pipes - redux
>Date: 30 Aug 1994 13:15:01 GMT
>Organization: Academic Administration Systems
>Lines: 13
>Distribution: world
>Message-ID: <33vbcl$8vn_at_news-feed-1.PeachNet.EDU>
>NNTP-Posting-Host: 168.24.241.72
>X-Newsreader: Nuntius Version 1.2
>X-XXDate: Tue, 30 Aug 1994 14:15:44 GMT
>
>OK- I have (sort of) created a Pro-C program to use DBMS pipes. When I
>compile with SQLCHECK=SEMANTICS, I get the following:
>PCC-S-0061: Error at line 38, column 24. PLS-201: identifier
>'SYS.DBMS_PIPE' must be declared
>
>this is on the end-exec line.
>
>It gives me an error for each DBMS_PIPE call.
>
>It still compiles, but I'm having problems that I believe are related to
>this.
>
>Any ideas??

User don't have execute privilege for sys.dbms_pipe. Give execute privilege to the user for dbms_pipe package.

I think it will solve the problem.

Johnson. Received on Wed Aug 31 1994 - 02:06:15 CEST