DBMS_PIPE « System Packages « Oracle PL / SQL

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.Run a DBMS_PIPE.RECEIVE_MESSAGE call to empty the local buffer
12.This script deletes a pipe if it exists in the context of the current session, then recreates it.
13.This script unpacks the local buffer.