Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Use DBMS_PIPE to pack message and send message

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>