Re: DBMS_PIPE Experts ! Help !^%$%

In article <38j2i4$onh_at_jalisco.optimum.net>, tim_boemker_at_zacatecas.optimum.com (Tim Boemker) writes:
|> 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

All roles are disabled inside stored procedures, so the grant needs to be made explicitly. Received on Tue Oct 25 1994 - 17:25:40 CET