# create wrapper subroutines for the Oracle
# PL/SQL package MyPackage 
use DBIx::ProcedureCall qw ( MyPackage:package );

# call a function in that package
# (passing in the DBI handle to use)
my $result = MyPackage::my_function( $dbh, 123, 456);