That code doesn't make sense. You are attempting to invoke fetchrow() and store its result in @array_c. Then you try to dereference $pointer, which you have not set.

My suggestion stands. Change the number of the index in my original code to match the position at which your 'ACCOUNT#' field is returned, or find that by doing:

my $index = map { next unless $_ eq 'ACCOUNT#'; $_ } @{$sth->{NAME}};
##Now, my original code:
@array_c = map { $$_[$index] } @{$sth->fetchall_arrayref()};
[download]