Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

DBMS_PIPE SEND_MESSAGE

SQL> SQL> DECLARE   2     lv_status_num PLS_INTEGER;   3  BEGIN   4     lv_status_num := DBMS_PIPE.SEND_MESSAGE('TEST 1');   5     DBMS_OUTPUT.PUT_LINE('Status: ' || lv_status_num);   6  END;   7  / PL/SQL procedure successfully completed. SQL>