Hi,
What i am able to understand from your code that you are trying to make a hash by fetching a data from a query .
Try this way also :

 
my $get_details = '';
my $get_data;
my $query = qq|write your query here ;|;

$get_details = $self->{_dbh}->prepare(qq{$query});#_dbh is a object de
+fined in your code u r doing it right .

    $get_details->execute($variables,$needed);# if no variable is need
+ed in the query then leave it empty


     while(my $details_dump =  get_details->fetchrow_hashref){

        push(@{$get_data}, $details_dump);

    }

    $get_details->finish;

    return $get_data;  #if you are using a it in a function this is re
+quired hash.
[download]

I think this will help you .
Thanks & regards