I think you want DBIx::ProcedureCall.

use DBIx::ProcedureCall qw(
   update_validation:package:procedure
);

update_validation::file_format_validation($dbh,$load_type, $product);
[download]