From oracle-l-bounce@freelists.org Thu Jun 17 02:54:24 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5H7rxM25715 for ; Thu, 17 Jun 2004 02:54:09 -0500 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 i5H7rl625676 for ; Thu, 17 Jun 2004 02:53:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0DC4372C8D1; Thu, 17 Jun 2004 02:38:15 -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 15245-74; Thu, 17 Jun 2004 02:38:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 58A2072C9FE; Thu, 17 Jun 2004 02:38:14 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 17 Jun 2004 02:36:51 -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 67BFA72C888 for ; Thu, 17 Jun 2004 02:36:50 -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 15245-43 for ; Thu, 17 Jun 2004 02:36:50 -0500 (EST) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.201]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id ECF1672C841 for ; Thu, 17 Jun 2004 02:36:49 -0500 (EST) Received: by mproxy.gmail.com with SMTP id 72so2747839rne for ; Thu, 17 Jun 2004 00:57:24 -0700 (PDT) Received: by 10.11.118.24 with SMTP id q24mr247857cwc; Thu, 17 Jun 2004 00:57:24 -0700 (PDT) Message-ID: <7765c89704061700572ec9505f@mail.gmail.com> Date: Thu, 17 Jun 2004 08:57:24 +0100 From: Niall Litchfield To: oracle-l@freelists.org Subject: Re: ORA-24347 Error In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII References: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2868 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Thanks Mark, and Kathy The problem *is* likely to be some oddity of the data - since the query only barfs for certain values of the string literals, but I also suspect that there is an underlying bug in some component here - as Mark says this corresponds to an OCI_SUCCESS_WITH_INFO status message - which shouldn't (in my book) result in the death of the process. I'm hoping that the outer joins are pointless - since this system has no NOT NULL columns. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com ---------------------------------------------------------------- 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 -----------------------------------------------------------------