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

##</code><code>##

$dbp->execute('dynamic_example', firstname => 'chris');