my $sql = "BEGIN :res := my_package.my_function; END;";
my $sth = $dbh->prepare($sql)
$sth->bind_param_inout( ":res", \$result, 0, { ora_type => ORA_RSET } );

##</code><code>##

use DBD::Oracle qw(ORA_RSET);