Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

We recently upgraded perl from 5.8 to 5.10

we discovered after the upgrade that the fetchrow_array loop ends abruptly

code snippet:
my $searchSQL = $dbh->prepare($sql1);
my $insertSQL = $dbh->prepare($sql2);

while (my ($id,$name) = $searchSQL->fetchrow_array()) {

if I comment out the "$insertSQL->execute($id,$name);" it loops thru all the records.

the code perfectly works in 5.8 but not in 5.10

any ideas?