Return-Path: Delivered-To: apmail-apr-dev-archive@www.apache.org Received: (qmail 61368 invoked from network); 18 Jan 2007 16:50:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Jan 2007 16:50:42 -0000 Received: (qmail 45898 invoked by uid 500); 18 Jan 2007 16:50:47 -0000 Delivered-To: apmail-apr-dev-archive@apr.apache.org Received: (qmail 45854 invoked by uid 500); 18 Jan 2007 16:50:46 -0000 Mailing-List: contact dev-help@apr.apache.org; run by ezmlm Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Id: Delivered-To: mailing list dev@apr.apache.org Received: (qmail 45842 invoked by uid 99); 18 Jan 2007 16:50:46 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Jan 2007 08:50:46 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [24.71.223.10] (HELO pd2mo1so.prod.shaw.ca) (24.71.223.10) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Jan 2007 08:50:37 -0800 Received: from pd4mr5so.prod.shaw.ca (pd4mr5so-qfe3.prod.shaw.ca [10.0.141.50]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0JC200BBTPDJ3R00@l-daemon> for dev@apr.apache.org; Thu, 18 Jan 2007 09:48:55 -0700 (MST) Received: from pn2ml1so.prod.shaw.ca ([10.0.121.145]) by pd4mr5so.prod.shaw.ca (Sun Java System Messaging Server 6.2-2.05 (built Apr 28 2005)) with ESMTP id <0JC200C9WPDIPPR1@pd4mr5so.prod.shaw.ca> for dev@apr.apache.org; Thu, 18 Jan 2007 09:48:54 -0700 (MST) Received: from [192.168.0.103] ([24.69.76.33]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0JC2003G9PCGA1O4@l-daemon> for dev@apr.apache.org; Thu, 18 Jan 2007 09:48:16 -0700 (MST) Date: Thu, 18 Jan 2007 08:48:49 -0800 From: Chris Darroch Subject: Re: DBD: Prepared statements, BLOBs etc. In-reply-to: <1169096010.2974.106.camel@shrek.rexursive.com> To: dev@apr.apache.org Message-id: <45AFA4F1.3030700@pearsoncmg.com> Organization: Pearson CTG/CMG MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en-ca, en-us X-Enigmail-Version: 0.93.0.0 References: <1155589108.3289.26.camel@shrek.rexursive.com> <44EF3BEF.7060901@pearsoncmg.com> <1156537930.2596.1.camel@shrek.rexursive.com> <20060831092218.nh0wn8ls00cg0c88@www.rexursive.com> <20060904084356.7prsyaa30g4kok08@www.rexursive.com> <44FE6D0B.90004@pearsoncmg.com> <20070115130619.1mmlk8lc00gk808c@www.rexursive.com> <1169087869.2974.99.camel@shrek.rexursive.com> <45AEFB2D.1080801@pearsoncmg.com> <1169096010.2974.106.camel@shrek.rexursive.com> User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.13) Gecko/20060423 X-Virus-Checked: Checked by ClamAV on apache.org Bojan Smojver wrote: > BTW, do you think OCI_NEW_LENGTH_SEMANTICS would be worth adding to > OCIEnvCreate() call? Apparently (according to the documentation :-), it > does this: > > OCI_NEW_LENGTH_SEMANTICS - byte-length semantics is used consistently > for all handles, regardless of character sets. > > Hopefully, this would then make sure OCILobRead() returns proper number > of bytes read. Might do, indeed, but it appears to only be available starting with 9i. Maybe that's sufficient for APR-util; 8i isn't supported anymore by Oracle, IIRC. (I say "might do" because I've tried using OCI_SHARED with OCIEnvCreate() and discovered that it merely triggered a fascinating bug, well-documented by other people in various bug reports to Oracle, and never fixed acknowledged as such. There may be a fix in 10g for it; I haven't checked. At any rate, it would be nice if OCI_NEW_LENGTH_SEMANTICS actually worked as promised. :-) Chris. -- GPG Key ID: 366A375B GPG Key Fingerprint: 485E 5041 17E1 E2BB C263 E4DE C8E3 FA36 366A 375B