Troubles using bind_param_array and execute_array with DBD::Ingres
- From: "Mia" <mmiaa@xxxxxxx>
- Date: 20 Jul 2005 09:49:11 -0700
Hi Everyone,
I posted a couple of weeks ago but didn't get any responses, and I'm
still stuck.
I'm trying to do bulk inserts into Ingres, but I can't get it to work.
Inserting one row of data at a time is OK:
for my $c (0 .. 1)
{
$sth2_put->bind_param
($c+1 , $row[$c], {TYPE => SQL_INTEGER});
}
$sth2_put->execute() || die $dbh2->errstr;
but trying this with array of values fails:
for my $c (0 .. 1)
{
$sth2_put->bind_param_array
($c+1 , $cols[$c], {TYPE=>SQL_INTEGER});
}
$sth2_put->execute_array({ArrayTupleStatus => \my @tuple_status}) ||
die $dbh2->errstr;
This produces an error: execute_array failed: E_US0B61 line 1, You
cannot assign a value of type 'varchar' to a column of type 'integer'.
Explicitly convert the value to the required type.
Am I using this correclty? Is this not fully implemented in
DBD::Ingres?
TIA
-Mia
.
- Prev by Date: Read/Write Oracle ORDImage?
- Next by Date: (Fwd) DBI support for arrayshash
- Previous by thread: Read/Write Oracle ORDImage?
- Next by thread: (Fwd) DBI support for arrayshash
- Index(es):
Relevant Pages
|
|
