$sth = $dbh->prepare('SELECT * FROM STORED_PROCEDURE WHERE ID=?') or die "prepare: $!";
$sth->execute($id);
...