Re: oracle woes

[prev] [thread] [next] [Date index for 2004/07/14]

On Wed, Jul 14, 2004 at 10:04:05AM +0100, Tim Bunce wrote:
> On Wed, Jul 14, 2004 at 12:58:03AM -0400, Perrin Harkins wrote:
> > On Tue, 2004-07-13 at 23:48, Randal L. Schwartz wrote:
> > > But the very same code under DBD::Oracle, I get:
> > > 
> > >     -> execute for DBD::Oracle::st (DBIx::ContextualFetch::st=HASH(0x6b926c)~0x6c4c14 My::DB::List=HASH(0x67c1fc) My::DB::Person=HASH(0x6abc50))
> > >     -- DBI::END
> > > 
> > > and then everything unwinds, die'ing with:
> > > 
> > >         Can't bind a reference (My::DB::List=HASH(0x67c1fc)) at /ssa/homedirs/02/48/merlyn/.cpan/lib/perl5/site_perl/5.8.3/DBIx/ContextualFetch.pm line 51.
> > > 
> > > How come?  Does DBD::Oracle not know how to view the ->id column
> > > to get to the real value for the SQL?  And if so, how should I have
> > > written this?
> > 
> > Sounds like a stringification problem.  Maybe DBD::Oracle is not
> > recognizing your ID as a string and forcing the context on your bind
> > variables correctly.
> 
> Yeap. I think that's the problem here. And just last night I made a
> release candidate for DBD::Oracle 1.16 available that probably fixes it:
> 
>  http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc1-20040713.tar.gz
> 
> If it doesn't then let me know (and I'll fix it for the full release)
> and meanwhile just stringify ("$foo") the args to execute.

I stole a little time to add a test and, of course, the quick fix
hadn't been enough.  Here's a new release candidate that should
work for you:

   http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc3-20040714.tar.gz

Please let me know.

Tim.