my $sql = "EXEC dynamic_example @firstname = ?"; $dbh->execute('chris%')