my $sth=$dbh->prepare('exec sp_MyStoredProg @foo=?');
$sth->execute($bar);