MERCHANTS_PKG.payments_technical_rep
(
in_merchant_id_arr IN typ_varchar2_arr, 
in_status_arr IN typ_varchar2_arr, 
in_rownum_cnt IN number,
in_date_from IN date,
in_date_to IN date,
in_sum_from IN number,
in_sum_to IN number,
in_search_txt IN varchar2,
out_cursor OUT sys_refcursor
) ;

@NamedStoredProcedureQuery(
        name = "PaymentsTechnicalRequest",
        procedureName = "MERCHANTS_PKG.payments_technical_rep",
        resultClasses = EcommMerchantRecord.class,
        parameters = {
                @StoredProcedureParameter(name = "in_merchant_id_arr", mode = ParameterMode.IN, type = String[].class),
                @StoredProcedureParameter(name = "in_status_arr", mode = ParameterMode.IN, type = String[].class),
                @StoredProcedureParameter(name = "in_rownum_cnt", mode = ParameterMode.IN, type = Integer.class),
                @StoredProcedureParameter(name = "in_date_from", mode = ParameterMode.IN, type = LocalDate.class),
                @StoredProcedureParameter(name = "in_date_to", mode = ParameterMode.IN, type = LocalDate.class),
                @StoredProcedureParameter(name = "in_sum_from", mode = ParameterMode.IN, type = BigDecimal.class),
                @StoredProcedureParameter(name = "in_sum_to", mode = ParameterMode.IN, type = BigDecimal.class),
                @StoredProcedureParameter(name = "in_search_txt", mode = ParameterMode.IN, type = String.class),
                @StoredProcedureParameter(name = "out_cursor", mode = ParameterMode.REF_CURSOR, type = Class.class)
        }
)

StoredProcedureQuery query = em
                .createNamedStoredProcedureQuery("PaymentsTechnicalRequest")
                .setParameter("in_merchant_id_arr", merchantIds)
                .setParameter("in_status_arr", statuses)
                .setParameter("in_rownum_cnt", rowsCount)
                .setParameter("in_date_from", dateFrom)
                .setParameter("in_date_to", dateTo)
                .setParameter("in_sum_from", amountFrom)
                .setParameter("in_sum_to", amountTo)
                .setParameter("in_search_txt", searchText);
        query.execute();
        return query.getResultList();

Caused by: org.hibernate.exception.GenericJDBCException: Error calling CallableStatement.getMoreResults
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	at org.hibernate.result.internal.OutputsImpl.convert(OutputsImpl.java:78) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	at org.hibernate.result.internal.OutputsImpl.<init>(OutputsImpl.java:55) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	at org.hibernate.procedure.internal.ProcedureOutputsImpl.<init>(ProcedureOutputsImpl.java:32) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	at org.hibernate.procedure.internal.ProcedureCallImpl.buildOutputs(ProcedureCallImpl.java:442) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	at org.hibernate.procedure.internal.ProcedureCallImpl.getOutputs(ProcedureCallImpl.java:393) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	at org.hibernate.procedure.internal.ProcedureCallImpl.outputs(ProcedureCallImpl.java:652) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	at org.hibernate.procedure.internal.ProcedureCallImpl.execute(ProcedureCallImpl.java:635) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	... 121 common frames omitted
Caused by: java.sql.SQLException: The number of parameter names does not match the number of registered praremeters
	at oracle.jdbc.driver.OracleSql.setNamedParameters(OracleSql.java:198) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0]
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4712) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0]
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:140) ~[bonecp-0.8.0.RELEASE.jar:na]
	at org.hibernate.result.internal.OutputsImpl.<init>(OutputsImpl.java:51) ~[hibernate-core-5.2.1.Final.jar:5.2.1.Final]
	... 126 common frames omitted