Run a DBMS_PIPE.RECEIVE_MESSAGE call to empty the local buffer : DBMS_PIPE « System Packages « Oracle PL / SQL






Run a DBMS_PIPE.RECEIVE_MESSAGE call to empty the local buffer

    
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL>
SQL>
SQL> 
SQL> SELECT   DBMS_PIPE.RECEIVE_MESSAGE('Nowhere',0)
  2  FROM     dual;

DBMS_PIPE.RECEIVE_MESSAGE('NOW
------------------------------
                             1

1 row selected.

SQL>
SQL>
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.Define an anonymous block to populate the local private pipe.
8.An anonymous block program to create a pipe.
9.An anonymous block program to delete a pipe
10.An Oracle9i Pipelined Table Function
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.