If the drivers for Oracle are like Informix you just have to treat the stored procedure just like a normal query: execute it first, then fetch from it to retreive the values. ie. my $sth = $dbh->prepare("execute new_procedure()"); $sth->execute(); my $rowref = $sth->fetch(); However a quick scan of my laptop shows that perldoc DBD states that calling stored procedures is driver dependent, so it may be slightly different for Oracle, good luck.