in reply to $dbh->selectall_arrayref to simple @array

See References quick reference. Basically you seem to want

my @emps = @{ $dbh->selectall_arrayref( ... ) };

[download]

In Section Seekers of Perl Wisdom