my $plch = join ', ', ('?') x @values;
my $sql = <<END_SQL;
SELECT COUNT(*)
  FROM some_table
  WHERE some_column IN ( $pclh )
END_SQL

my $sth = $dbh->prepare_cached($sql) || die;

$sth->execute(@values) || die;

while ($sth->fetch) {
    # Do stuff
}

$sth->finish || die;