my $names = $sth->{NAME};
#$names is an array reference
for (@$names) {
   print $_, "\n";
}

##</code><code>##

my $types = $sth->{TYPE};
#$types is an array reference
for (@$types) {
   print $_, "\n";
}