Right.
So what you now need to do is to check for errors when preparing and executing your sql statement.
If your code if breaking you are not notified because of the eval block.
Modify the prepare and execute statements to look something like this

    my $func = $dbh->prepare( 
      ...
   }) or die DBI->errstr;
...
    $func->execute or die DBI->errstr;
[download]

This will tell you if there is any problem when executing that code, namely if the user that is connecting to the database is granted the required permissions to do what you want it to.