$sth = $dbh->prepare($sql); $sth->execute('TESTA1', 'TESTA2', 'TESTA3'); $aref = $sth->fetchall_arrayref({stuff => here});