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>