use MyProcedures qw (dbms_random.random );

# this creates:
   sub CallingPackage::dbms_random_random {
       # call dbms_random.random in the database
   }