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> --