# 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);

##</code><code>##

my $result = $dbh->MyPackage::my_function( 123, 456);

##</code><code>##

my $result = $dbh->selectrow_arrayref('select * from blah');