Use DBMS_PIPE to pack message and send message : DBMS_PIPE « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_PIPE
SQL>
SQL> DECLARE
  2     pipe_status INTEGER;
  3     mypipe VARCHAR2(128) := DBMS_PIPE.UNIQUE_SESSION_NAME;
  4  BEGIN
  5     DBMS_OUTPUT.PUT_LINE ('Write to ' || mypipe);
  6     DBMS_PIPE.PACK_MESSAGE (SYSDATE);
  7     pipe_status := DBMS_PIPE.SEND_MESSAGE (mypipe);
  8  END;
  9  /
Write to ORA$PIPE$002004930001

PL/SQL procedure successfully completed.

SQL>








31.18.DBMS_PIPE
31.18.1.DBMS_PIPE.CREATE_PIPE
31.18.2.DBMS_PIPE.RECEIVE_MESSAGE with timeout
31.18.3.DBMS_PIPE.SEND_MESSAGE with timeout
31.18.4.DBMS_PIPE.SEND_MESSAGE
31.18.5.DBMS_PIPE.PACK_MESSAGE
31.18.6.DBMS_PIPE.REMOVE_PIPE
31.18.7.DBMS_PIPE.RECEIVE_MESSAGE
31.18.8.Use dbms_pipe package
31.18.9.DBMS_PIPE.RESET_BUFFER
31.18.10.DBMS_PIPE.UNPACK_MESSAGE and record type
31.18.11.Use DBMS_PIPE to pack message and send message