An anonymous block program to delete a pipe : DBMS_PIPE « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. DBMS_PIPE

An anonymous block program to delete a pipe

    

SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL>
SQL> 
SQL> DECLARE
  2
  3    
  4    returnValue INTEGER;
  5
  6    
  7    FUNCTION get_user
  8      RETURN VARCHAR2 IS
  9
 10    BEGIN
 11
 12    
 13      FOR i IN (SELECT user FROM dual) LOOP
 14        return i.user;
 15      END LOOP;
 16
 17    END get_user;
 18
 19  BEGIN
 20
 21    
 22    returnValue := DBMS_PIPE.REMOVE_PIPE(get_user||'$'||'MESSAGE_INBOX');
 23    returnValue := DBMS_PIPE.REMOVE_PIPE(get_user||'$'||'MESSAGE_OUTBOX');
 24
 25  END;
 26  /

PL/SQL procedure successfully completed.








Related examples in the same category

1.DBMS_PIPE.PACK_MESSAGE
2.DBMS_PIPE.UNPACK_MESSAGE
3.dbms_pipe.remove_pipe
4.Use DBMS_PIPE package to receive a message.
5.Use DBMS_PIPE package to send a message.
6.Use DBMS_PIPE.PACK_MESSAGE in a trigger
7.Define an anonymous block to populate the local private pipe.
8.An anonymous block program to create 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.