I have found better success with: fetchall_arrayref({}) as suggested by Happy-the-monk, especially if you are expected expecting more rows. Try something like this:

. . .
$pointer = $sth -> fetchall_arrayref({});

    for my $i (0 .. $#$pointer) {
        my $num = $pointer->[$i]{'NUM'};
        my $name = $pointer->[$i]{'name'};
        
        print "NAME = $name<br />";
    }
[download]

Suggested reading.