From oracle-l-bounce@freelists.org Mon Jan 10 14:03:42 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0AK3gr06513 for ; Mon, 10 Jan 2005 14:03:42 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j0AK3fn06504 for ; Mon, 10 Jan 2005 14:03:41 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BFD1272CA00; Mon, 10 Jan 2005 15:10:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05241-46; Mon, 10 Jan 2005 15:10:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 284E572C094; Mon, 10 Jan 2005 15:07:22 -0500 (EST) Message-ID: <1105387400.41e2df88dff4f@mail.online.ie> Date: Mon, 10 Jan 2005 12:03:20 -0800 From: Ankur Shah To: oracle-l@freelists.org Subject: RE: Verify Piipe Exists MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.4 X-Originating-IP: 167.193.156.101 X-archive-position: 14569 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: desert_moon@online.ie Precedence: normal Reply-To: desert_moon@online.ie X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Try using reset_buffer declare ret number; begin=20 dbms_pipe.purge('usernamePIPE_MASTER'); ret:=3Ddbms_pipe.remove_pipe(user||'pipe_master1'); DBMS_PIPE.RESET_BUFFER; end; ================= HTHU Ankur Shah Oracle DBA DHR/Public Heatlth,Georgia. I am trying to install a vendor application with an Oracle repository = and not making much progress. The install has failed and the cleanup = requires that the pipe be purged and removed or the database be bounced. = I've been through this four times since Friday afternoon. I can't find = any way to view whether or not a pipe exists. I know its not a = conventional database object and that its some sort of memory structure. = Is there a way to do this? Where do I look? This is what they gave me to remove the pipe. declare ret number;=20 begin=20 dbms_pipe.purge('usernamePIPE_MASTER');=20 ret:=3Ddbms_pipe.remove_pipe(user||'pipe_master1');=20 end;=20 -- http://www.freelists.org/webpage/oracle-l