my $sth=$dbh->prepare("exec OSP_FOO_BAR(?,?,?)")
   or die $dbh->errstr;
$sth->execute($xvar,$yvar,$zvar) 
   or die $sth->errstr;