I'm not sure if this applies exactly or not, but there's a DBI func method that I use with Oracle to get stored procedure output. The code for doing that looks like this:

my $flag = 'foo';

$dbh->func(1000000, 'dbms_output_enable');
$sth = $dbh->prepare(" BEGIN do.pl(?); END; ");
$sth->execute($flag);
$result = $dbh->func('dbms_output_get');
print $result;
$sth->finish();
[download]