Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

DBMS_PIPE REMOVE_PIPE

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