My Oracle Support Banner

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

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.