|
SQL>
SQL> DECLARE
2 pipe_status INTEGER;
3 mypipe VARCHAR2(128) := DBMS_PIPE.UNIQUE_SESSION_NAME;
4 BEGIN
5 DBMS_OUTPUT.PUT_LINE ('Write to ' || mypipe);
6 DBMS_PIPE.PACK_MESSAGE (SYSDATE);
7 pipe_status := DBMS_PIPE.SEND_MESSAGE (mypipe);
8 END;
9 /
Write to ORA$PIPE$002004930001
PL/SQL procedure successfully completed.
SQL>
|