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>