my $sth = $dbh->prepare("SELECT id,name,age FROM foo");
$sth->execute();

while (my $row = $sth->fetchrow())
{
     $self->some_function(@$row);
}