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, fromhdr,

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, fromhdr,

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