my $sth = $dbh->prepare(<<SQL)
INSERT INTO needed_details (quantity,item_number)
VALUES (?,?)
SQL
# Error-check here.

foreach my $quantity (@quantity) {
    $sth->execute($quantity,$item_number);
    # Error check here.
}