my $sth = $dbh->prepare("EXEC sp_myproc ?, ?");
my $id = $sth->execute('foo', 'bar');