in reply to Process Text File and Write to Database

It looks like you never call $query_handle->execute(); because of the unconditional next; in your while loop:
while (<INPUT>) { my $name = $connect->quote($_); next;
That first connect is the only one that ever gets called in your loop. That doesn't seem right.