DBMS_PIPE.REMOVE_PIPE Does Not Remove Explicit Pipe (Doc ID 1264071.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Server - Enterprise Edition ~ PRODACTIVE - Version: 11.2.0.1 ~ ACTIVE to 11.2.0.2 ~ ACTIVE - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms

Oracle 11g Release 2 - 11.2.0.2, the pipes are shown as 0 in PIPE_SIZE even after removing the pipes using dbms_pipe.remove_pipe. 

-- Checking for Pipes before actually created the pipes:

SQL> select * from v$db_pipes; 

no rows selected 

-- Explicit Pipes are created: 

SQL> declare 
ignore number; 
begin 
ignore := DBMS_PIPE.CREATE_PIPE('test_pipe'); 
end; 
/   

-- Checking for Pipes after actually creating the pipes:

SQL> select * from v$db_pipes; 

  OWNERID 
---------- 
NAME 
------------------------ 
TYPE     PIPE_SIZE 
------- ---------- 
        0 
TEST_PIPE 
PRIVATE       1618 

-- Explicit Pipes are removed by calling dbms_pipe.remove_pipe: 

SQL> declare 
ignore number; 
begin 
ignore := dbms_pipe.remove_pipe('test_pipe'); 
end; 
/   

Changes

Migrated or Upgraded to Oracle 11g Release 2

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms