Re: declare SYS.DBMS_PIPE???

mcstock wrote:

> that probably means that the schema you're using does not have execute
> permission on DBMS_PIPE (there apparently is a public synonym mapping
> DBMS_PIPE to SYS.DBMS_PIPE, since the error message figured out the package
> owner)
>
> if you're creating a stored procedure, the schema must have EXECUTE
> permission directly granted to it (not via a role) or EXECUTE permission
> must be granted to PUBLIC (which not every dba would want to do with
> DBMS_PIPE)
    That's what I thought was happening. However, as I posted in another message, the GRANT command is hanging up and timing out.

-Greg G Received on Thu Nov 06 2003 - 09:21:13 CST