dbms_pipe.remove_pipe : DBMS_PIPE « System Packages « Oracle PL / SQL

dbms_pipe.remove_pipe

    
SQL>
SQL>    DECLARE
  2          v_stat NUMBER ;
  3     BEGIN
  4          v_stat := dbms_pipe.remove_pipe('myprivatepipe');
  5          DBMS_OUTPUT.PUT_LINE('The status for removing the private pipe is: ' || v_stat);
  6          v_stat := dbms_pipe.remove_pipe('mypublicpipe');
  7          DBMS_OUTPUT.PUT_LINE('The status for removing the public pipe is: '|| v_stat);
  8    END;
  9  /
The status for removing the private pipe is: 0
The status for removing the public pipe is: 0

PL/SQL procedure successfully completed.

SQL>
SQL> --

Related examples in the same category

1.	DBMS_PIPE.PACK_MESSAGE
2.	DBMS_PIPE.UNPACK_MESSAGE
3.	Use DBMS_PIPE package to receive a message.
4.	Use DBMS_PIPE package to send a message.
5.	Use DBMS_PIPE.PACK_MESSAGE in a trigger
6.	Define an anonymous block to populate the local private pipe.
7.	An anonymous block program to create a pipe.
8.	An anonymous block program to delete a pipe
9.	An Oracle9i Pipelined Table Function
10.	Run a DBMS_PIPE.RECEIVE_MESSAGE call to empty the local buffer
11.	This script deletes a pipe if it exists in the context of the current session, then recreates it.
12.	This script unpacks the local buffer.