my $query = "exec OSP_FOO_BAR(?, ?, ?)";
my $sth = $dbh->prepare($query);

$sth->execute($xvar, $yvar, $zvar);