On Thu, Oct 21, 2004 at 05:00:56PM -0500, Scott T. Hildreth wrote:
> Tim,
> Are you still maintaining DBD::Proxy?
Yes, with a loose definition of the word "maintaining".
> Have you had a request for supporting named parameters?
Tim Howell [CC'd] volunteered but not much has happened.
I could give you commit rights to the ./lib/DBD and ./t
directories if you want to help out.
But note that changes to the proxy must take into account that some
people may not be able to upgrade either the client or the server
at the same time - so backwards compatibility is needed on both sides.
I've been bitten by releases that have broken that in the past.
Also the "bind ':p1' using '1'" trick you mention below only applies
to DBD::Oracle.
Tim.
> STH
>
> On Thu, 2004-10-21 at 16:55, Scott T. Hildreth wrote:
> > I was going bring this up myself. I had this problem the other day.
> > To get it working I changed the param names to :p1, :p2, ...etc and
> > used $sth->bind_param(1, 'foo'). For the return param I had to use the
> > a :p? as well,
> >
> > i.e.
> >
> > my $sth = $dbh->prepare(q{
> > BEGIN
> > :p3 = some_pkg(:p1, :p2)
> > END;
> > });
> >
> > $sth->bind_param(1, 'foo');
> > $sth->bind_param(2, 'bar');
> >
> > $sth->bind_param_inout(3, \$var, 10);
> >
> > I was considering trying to change DBD::Proxy to use named parameters.
> > We use DBD::Proxy quite a bit. I didn't know if someone else is
> > working on it already, so I guess I am asking now?
> >
> > STH
> >
> > On Thu, 2004-10-21 at 16:34, Steve Baldwin wrote:
> > > We make extensive use of named bind params in our apps (our DB is Oracle).
> > > I just tried running a test program over DBD::Proxy and found it barfs on
> > > these. Here is the code in DBD::Proxy that doesn't like them .
> > >
> > >
> > >
> > > sub bind_param ($$$@) {
> > >
> > > my $sth = shift; my $param = shift;
> > >
> > > $sth->{'proxy_params'}->[$param-1] = [EMAIL PROTECTED];
> > >
> > > }
> > >
> > >
> > >
> > > Doing a google search on this turned up some pretty old stuff - e.g.
> > >
> > >
> > >
> > > http://www.grin.net/~mirthles/pile/dbi-tim_bunce_call_on_proxy_module_with_o
> > > racle_bind_param.html
> > >
> > >
> > >
> > > Does anyone know whether a fix to DBD::Proxy is planned?
> > >
> > >
> > >
> > > Thanks,
> > >
> > >
> > >
> > > Steve
> > >
