my $sql = "mystoredprocedure 'value1','value2'";
my $sth = dbh->prepare($sql);
my $ret = $sth->execute();
my $recs = $sth->fetchrow_hashref();