Re: Problem using DBMS_PIPE

James,

        Try the following:
CREATE PUBLIC SYNONYM DBMS_PIPE FOR SYS.DBMS_PIPE; GRANT EXECUTE ON DBMS_PIPE TO PUBLIC;         parris geiser

James Scharpf (james.scharpf_at_microchip.com) wrote:
> Hello,
 

> I am trying to use DBMS_PIPE package for the first time, with little
> success. When I attempt to create the procedure that utilizes this
> package, certain procedures (create_pipe, send_message, receive_message)
> are not recognized and I get the following messages
 

> PLS-00221: 'CREATE_PIPE' is not a procedure or is undefined
> PL/SQL: Statement ignored
> PLS-00221: 'SEND_MESSAGE' is not a procedure or is undefined
> PL/SQL: Statement ignored
> PLS-00221: 'RECEIVE_MESSAGE' is not a procedure or is undefined
> PL/SQL: Statement ignored
 

> On the other hand, certain procedures _are_ recognized (pack_message,
> receive message). No error msg is received on these calls.
 

> Furthermore, if the offending lines are commented out and the procedure
> is compiled and run, the expected --
 

> ORA-06556: the pipe is empty, cannot fulfill the unpack_message request
 

> is received, reinforcing the notion that DBMS_PIPE.unpack_message exists.
 

> To the best of my knowledge, all of the appropriate scripts have been run
> (catproc.sql, standard.sql, and all of the dbmsxxxx.sql scripts
> including dbmspipe.sql). Also, I believe the appropriate priv's have been
> granted .
 

> Thanks in advance for any help you might be able to provide,
> --
> James Scharpf
> email: james.scharpf_at_microchip.com
Received on Tue May 28 1996 - 00:00:00 CEST