Home -> Usenet -> comp.databases.oracle -> Re: DBMS_PIPE Experts ! Help !^%$%

Re: DBMS_PIPE Experts ! Help !^%$%

From: Tim Boemker <tim_boemker_at_zacatecas.optimum.com>
Date: 25 Oct 1994 13:52:04 GMT
Message-ID: <38j2i4$onh_at_jalisco.optimum.net> 







In article <Cy6ADx.I28_at_nl.oracle.com>
cgohring_at_lucifer (Carl Gohringer) writes:



> DBMS_PIPE is an object owned by SYS.


> Any other user that wants to use it needs to be granted access by SYS.





The stated solution worked for me (once I deleted the bogus keyword
execute).  However, before I made the grant I tried to execute the
package using a role that had execute any procedure, and I got the same
error.  Any idea why?



Tim Boemker
Received on Tue Oct 25 1994 - 14:52:04 CET












Original text of this message