my $sth_insert = $dbi->prepare(<<'SQL');
    INSERT INTO biochemical
         VALUES (?,?,?,?,?,?,?,?,?,?,...,?)
SQL

for my $row (@rows) {
    $sth_insert->execute( @$row );
};

##</code><code>##

local $sth_insert->{RaiseError} = 0;
for my $row (@rows) {
    $sth_insert->execute( @$row );
};