Mailing-List: contact dev-help@apr.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (herse.apache.org: domain of bojan@rexursive.com designates
 203.171.74.242 as permitted sender)
Subject: Re: DBD: Prepared statements, BLOBs etc.
From: Bojan Smojver <bojan@rexursive.com>
To: Geoffrey Giesemann <geoffwa@cs.rmit.edu.au>
Cc: dev@apr.apache.org
In-Reply-To: <20070118031707.GA7857@cs.rmit.edu.au>
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>
	 <20070118031707.GA7857@cs.rmit.edu.au>
Content-Type: text/plain
Date: Fri, 19 Jan 2007 07:34:06 +1100
Message-Id: <1169152446.2974.114.camel@shrek.rexursive.com>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Thu, 2007-01-18 at 14:17 +1100, Geoffrey Giesemann wrote:

> Can you try:
> 
> INSERT INTO Print_media(Product_id, Ad_id, Ad_sourcetext VALUES
>  (2004, 1, TO_LOB(:SRCTXT))
>            ^^^^^^
> instead?

Unfortunately, changing SQL wasn't an option, as this is something users
carve by hand and give to APU DBD. The goal is that it should "just
work", for most common cases.

> This suggests that the implicit data type for :SRCTXT is a LONG (for
> some reason).  Is there a more specific bind type you could use? (other
> than SQLT_CHR)

The fix was actually to use types depending on the nature of LOB. For
CLOBs, either SQLT_CHR or SQLT_LNG worked fine. But for BLOBs, one needs
to use SQLT_LBI (or maybe something else I'm yet unaware of). And since
my test table had a mix of both and Oracle wouldn't tell me on which
column the problem actually was, plus the fact that I didn't find the
SQLT_LBI mentioned anywhere in the docs, it took a while to figure
things out. 

Thanks for your help,
-- 
Bojan