From oracle-l-bounce@freelists.org Tue Mar 30 11:17:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2UHH6o02077 for ; Tue, 30 Mar 2004 11:17:06 -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 i2UHH5o02069 for ; Tue, 30 Mar 2004 11:17:06 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B6979634ACA; Tue, 30 Mar 2004 12:13:37 -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 00575-63; Tue, 30 Mar 2004 12:13:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09F356344FA; Tue, 30 Mar 2004 12:13:37 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 30 Mar 2004 12:12:28 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 549F663427C for ; Tue, 30 Mar 2004 12:12:28 -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 00576-44 for ; Tue, 30 Mar 2004 12:12:28 -0500 (EST) Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 014816340F3 for ; Tue, 30 Mar 2004 12:12:28 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 30 Mar 2004 17:20:31 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B0031D@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: ORA-03113 end of file on communication channel Date: Tue, 30 Mar 2004 11:16:59 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2083 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Juan How did you decide the pipelined function was causing your problem? Did Oracle Support locate that as the source of the error? Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Juan Cachito Reyes Pacheco Sent: Tuesday, March 30, 2004 11:14 AM To: oracle-l@freelists.org Subject: Re: ORA-03113 end of file on communication channel Usually this error is generated because there is a bug. The best thing you could do if you can't solve it is to search the bug list or set a tar on the subject to Oracle. And then apply the patch or do a workaround. For example I had this problem when used pipelined functions. instead using pipelined, I used cursor. Juan Carlos Reyes Pacheco OCP Database 9.2 Standard Edition ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------