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>