Re: DBD::Oracle and bulk binds via execute_array

2003-10-09 Thread Kristian Nielsen
"Dean Arnold" <[EMAIL PROTECTED]> writes: > Does this need to be modified to provide the column type info ? I don't see > anything in the DBI 1.38 POD indicating type info can be specified...tho > I spose the bind_param() i/f (wo binding data) can be used as a cheat ? Where non-default types are

Re: bytea escaping?

2003-10-09 Thread Ragnar Hojland Espinosa
On Wed, Oct 08, 2003 at 09:48:56AM -0700, David Wheeler wrote: > On Wednesday, October 8, 2003, at 08:55 AM, Ragnar Hojland Espinosa > wrote: > > > > >Hi David, hm i thought i had mentioned it too.. but that doesnt > >work either: > > > >my $sth = $dbh->prepare ("INSERT INTO emails (id, from

Re: bytea escaping?

2003-10-09 Thread Tim Bunce
On Wed, Oct 08, 2003 at 09:48:56AM -0700, David Wheeler wrote: > On Wednesday, October 8, 2003, at 08:55 AM, Ragnar Hojland Espinosa > wrote: > > > > >Hi David, hm i thought i had mentioned it too.. but that doesnt > >work either: > > > >my $sth = $dbh->prepare ("INSERT INTO emails (id, from

Re: bytea escaping?

2003-10-09 Thread David Wheeler
On Thursday, October 9, 2003, at 04:25 AM, Tim Bunce wrote: That's because you're binding it twice. You need to bind each argument with bind_param(), and then call execute() without any arguments. That shouldn't be needed according to the DBI spec. The type set by a previous bind_param() is 'stic