My Oracle Support Banner

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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