DBMS_PIPE.RECEIVE_MESSAGE : DBMS_PIPE « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_PIPE
SQL>
SQL>
SQL> DECLARE
  2     lv_status_num PLS_INTEGER;
  3  BEGIN
  4     lv_status_num := DBMS_PIPE.RECEIVE_MESSAGE('TEST 1');
  5     DBMS_OUTPUT.PUT_LINE('Status: ' || lv_status_num);
  6  END;
  7  /

PL/SQL procedure successfully completed.








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