my $csr = $dbh->prepare(q{
        BEGIN
          schema.package.stored_procedure(:param1, :param2);
        END;
        });
    $csr->bind_param(':param1',  $param1);
    $csr->bind_param(':param2',  $param2);
    ...