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)
--
Mark C. Stock
email mcstock -> enquery(dot)com
www.enquery.com
(888) 512-2048
"Greg G" <ggershSNACK_at_CAKEctc.net> wrote in message
news:fJudnYBjA5GOxTeiRVn-ug_at_ctc.net...
>
> This is really strange. I coped some code from another user's area in
> my database, but when I go to compile it, I get this message:
>
> Line # = 32 Column # = 5 Error Text = PLS-00201: identifier
> 'SYS.DBMS_PIPE' must be declared
>
> The code is really simple stuff, along the lines of
> ...
> dbms_pipe.pack_message(v_pname);
> ...
>
> I can't find anything that tells me how, when, where or why to declare
this.
>
> Any ideas?
>
> -Greg G
>
Received on Thu Nov 06 2003 - 08:23:33 CST
