Perhaps a better way would be to:

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

This way you can capture any errors you generate and you are allowing the DBI interface to do what it does very well and handle any necessary type coversions for your variables.

Hope this helps.

---

Peter L. Berghold	Brewer of Belgian Ales
Peter@Berghold.Net	www.berghold.net
Unix Professional