From oracle-l-bounce@freelists.org Wed May 5 14:53:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45JrS123581 for ; Wed, 5 May 2004 14:53:38 -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 i45JrI623498 for ; Wed, 5 May 2004 14:53:28 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 312D172DB5E; Wed, 5 May 2004 14:41:40 -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 28179-60; Wed, 5 May 2004 14:41:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 83EDD72DB54; Wed, 5 May 2004 14:41:36 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 14:40:17 -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 1DA4E72D7B8 for ; Wed, 5 May 2004 14:40:11 -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 27691-62 for ; Wed, 5 May 2004 14:40:10 -0500 (EST) Received: from deet.btinternet.com (deet.btinternet.com [194.73.73.29]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1AC2872DA50 for ; Wed, 5 May 2004 14:40:10 -0500 (EST) Received: from [217.42.79.77] (helo=Primary) by deet.btinternet.com with smtp (Exim 3.22 #25) id 1BLSSu-0007ci-00 for oracle-l@freelists.org; Wed, 05 May 2004 20:54:00 +0100 Message-ID: <017701c432da$b5f68d70$7102a8c0@Primary> From: "Jonathan Lewis" To: References: <6.1.0.6.2.20040505130500.02a28558@pop.centrexcc.com> <016001c432d5$a52bcaf0$7102a8c0@Primary> <6.1.0.6.2.20040505134207.02a593d0@pop.centrexcc.com> Subject: Re: Wrong results using decode when db upgraded to 9205 Date: Wed, 5 May 2004 20:54:00 +0100 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4505 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jonathan@jlcomp.demon.co.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Correct. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Optimising Oracle Seminar http://www.jlcomp.demon.co.uk/seminar.html ----- Original Message ----- From: "Wolfgang Breitling" To: Sent: Wednesday, May 05, 2004 8:49 PM Subject: Re: Wrong results using decode when db upgraded to 9205 Hmm, interesting. Could it be that if Oracle finds an exact match for the sql in the shared pool that it doesn't bother doing the bind variable rewrite for cursor_sharing=force ? ---------------------------------------------------------------- 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 -----------------------------------------------------------------