Define an anonymous block to populate the local private pipe. : DBMS_PIPE « System Packages « Oracle PL / SQL






Define an anonymous block to populate the local private pipe.

    
SQL> DECLARE
  2
  3    
  4    message   VARCHAR2(30 CHAR);
  5    success   INTEGER;
  6
  7  BEGIN
  8
  9    
 10    message := DBMS_PIPE.UNIQUE_SESSION_NAME;
 11
 12    
 13    DBMS_PIPE.RESET_BUFFER;
 14
 15    
 16    DBMS_PIPE.PACK_MESSAGE(message);
 17
 18    
 19    DBMS_OUTPUT.PUT_LINE('Written to pipe ['||message||']');
 20
 21  END;
 22  /
Written to pipe [ORA$PIPE$0023000C0001]

PL/SQL procedure successfully completed.

SQL>

   
    
    
    
  








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