warn Dumper \@SQLvars;

##</code><code>##

$VAR1 = [
          {
            'COLX' => 'TESTA1',
            'COLY' => 'TESTA2',
            'COLZ' => 'TESTA3'
          },
          {
            'COLX' => 'TESTB1',
            'COLY' => 'TESTB2',
            'COLZ' => 'TESTB4'
          },

##</code><code>##

my $sth = $dbh->prepare($SQLQueryString);
my $array_ref = $dbh->selectall_arrayref( $SQLQueryString, { Slice => {} }, @SQLvars );

##</code><code>##

DBD::Oracle::db selectall_arrayref failed: called with 9 bind variables when 3 are needed