| Subject: | ora_array_chunk_size possibly broken |
I've not tested this yet but I thought it was worth reporting and I'll
look at it myself. I copied DBD::Oracle's code for execute_for_fetch as
a starter for implementing this in DBD::ODBC but had problems setting
the chunk size. The code:
sub execute_for_fetch {
my ($sth, $fetch_tuple_sub, $tuple_status) = @_;
my $row_count = 0;
my $err_count = 0;
my $tuple_count="0E0";
my $tuple_batch_status;
my $dbh = $sth->{Database};
my $batch_size =($dbh->{'ora_array_chunk_size'}||= 1000);
probably always sets $batch_size to 1000 as
$dbh->{'ora_array_chunk_size'} probably always returns undef. I think it
should be $dbh->FETCH('ora_array_chunk_size').
I will check this.
Martin
--
Martin J. Evans
Wetherby, UK