my @books = qw(1 2 3 4 5);
my $sql = qq(insert into temp_selectedTitles values (?));
my $sh = $pics->prepare($sql);
$sh->bind_param_array(1, [@books]);

#this returns no rows
my $tuples = $sh->execute_array({}, \@books);

#this returns the error 'DBD::Oracle::st execute_array failed: 0 bind values supplied but 1 expected...'
my $tuples = $sh->execute_array({\ArrayTupleFetch=>$sh});