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.