...
use Data::Dumper;
...
my @ref_header = ( 
       [ ["Name", "Surname"] ],
    );
...
@ref_db_data = $sth->fetchall_arrayref;
[download]

print Dumper @ref_db_data;
$VAR2 = [
          [
            'John',
            'Doe'
          ],
          [
            'Jane',
            'Smith'
          ],
        ];
[download]

Your @ref_db_data is going to be a one-element array with an array reference as that one element. There's nothing wrong with that, but it might not be what you really want.

I'm guessing what you're shooting for is this:

my $ref_header = [ 'Name', 'Surname' ];
my @ref_db_data = @{ $sth->fetchall_arrayref };
unshift @ref_db_data, $ref_header;
[download]

Or maybe this:

my $ref_header = [ 'Name', 'Surname' ];
my $ref_db_data = $sth->fetchall_arrayref;
unshift @{ $ref_db_data }, $ref_header;
[download]

Here's your original situation:

my @ref_header = ( 
       [ ["Name", "Surname"] ],
    );
...
@ref_db_data = $sth->fetchall_arrayref;
unshift @{$ref_db_data[0]}, $ref_header[0]->[0];
[download]

...but I'm not sure if that's what you're shooting for. You wind up with something like:

@ref_db_data = ( [ [ 'Name', 'Surname' ],
                   [ 'John', 'Doe'     ],
                   [ 'Jane', 'Smith'   ]
                 ]
               );
[download]

Thank you Kyle!!!!!!!!

unshift @{$ref_db_data[0]}, $ref_header[0]->[0];
[download]

this is all I needed to fix my array :) This is proof that the knowledge of the monks are supreme!!!!