Re: declare SYS.DBMS_PIPE???

i hadn't seen that post ...

what ORA- error are you getting?

also, check DBA_TAB_PRIVS to make sure if the missing grant is the problem or not

"Greg G" <ggershSNACK_at_CAKEctc.net> wrote in message news:cbOdnQCqfsya-jeiRVn-jA_at_ctc.net...
>
>
> 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:41:55 CST