Re: How to Use DBMS_PIPE

On Fri, 21 Feb 1997 11:53:16 -0500, Anil Sam <zephyr_at_grfn.org> wrote:

>
>I am trying to use DBMS_PIPE. Whenever I give the following commands from
>SQL prompt I get the following error message. If anybody aware how to
>overcome this problem, please let me know.
>
>select dbms_pipe.create_pipe('Tapas') from dual;
>
>ORA-06571: Function create_pipe does not gurantee not to update the
>database.
>Whenver I try to use any function it come up with the same error.
>
>Thanx
>Tapas
>

I've tried your issue on our system (Workgroup server 7.1.3 on Netware) but it seems that your RDBMS is more recent because the create_pipe procedure is not present in our DBMS_PIPE package. In our version the pipe is created implicitly when calling send_message.

But, did you tried
  execute dbms_pipe.create_pipe('Tapas'); instead of 'select from dual'.

Hope it works,

Carl Van de Casteele
E&Y Consulting Received on Tue Mar 04 1997 - 00:00:00 CST