$myarrayref = [ 
   { NAME => 'Bob' , JOB => 'Programmer'} ,
   { NAME => 'Bill' , JOB => 'Manager'} ,
];

##</code><code>##

$template->param( EMPLOYEE_INFO => $myarrayref);

##</code><code>##

# Create statement handle
$sth = $dbh->prepare($somesql);

# execute statement handle
$sth->execute();

# loop through rows
while ($hashref = $sth->fethrow_hashref()) {
   push @$myarrayref , $hashref;
}

# clean up statement handle
$sth->finish();

##</code><code>##

$template->param(EMPLOYEE_INFO => $myarrayref);