...
@In
EntityManager em;
...
List<Object[]> resultList = (List<Object[]>)em.createNativeQuery("{? = call myFunction(:startDate,:endDate)}")
.setParameter("startDate", start)
.setParameter(""endDate",end)
.getResultList();

create or replace function mttIncommingReport1(startDate Date, endDate Date)
RETURN SYS_REFCURSOR is

    mtt_cursor SYS_REFCURSOR;
begin
  OPEN mtt_cursor FOR
  
select to_char(с.db, 'HH:MI:SS') "Время", dcc.call_duration_sek(с.id) "Длительность, сек",
 s3.lname "Оператор", m.bn "Входящий номер", m.memo "Регион", s1.memo "Клиент", s2.memo "ФЛ/ЮЛ", s3.memo "Тип разговора",
 s4.t_memo "Тема", s4.pt_memo "Подтема", с.an "Номер абонента"
from dcc.callcard с, dcc.vbn b, vs.mtt_noms m,
       (select c.id id, ct.memo memo 
        from dcc.callcard c, dcc.call_theme ct, dcc.theme t, dcc.vbn b
        where c.id=ct.id and ct.idt=t.idt and t.memo like 'Тип клиента%' and c.bn=b.cbn
         and b.bn in (21,22,23,24,25,26) and c.db>=startDate and c.db<=endDate) s1,
       (select c.id id, ct.memo memo 
        from dcc.callcard c, dcc.call_theme ct, dcc.theme t, dcc.vbn b
        where c.id=ct.id and ct.idt=t.idt and t.memo like 'Тип контакта%' and c.bn=b.cbn 
        and b.bn in (21,22,23,24,25,26) and c.db>=startDate and c.db<=endDate) s2,
        (select c.id id, ct.memo memo, o.lname lname
        from dcc.callcard c, dcc.call_theme ct, dcc.theme t, dcc.vbn b, dcc.operator o
        where c.id=ct.id and ct.idt=t.idt and t.memo like 'Тип разговора%' and c.bn=b.cbn
         and b.bn in (21,22,23,24,25,26) and o.ido=ct.ido and c.db>=startDate and c.db<=endDate) s3,          
        (select c.id, ss1.memo t_memo,ss2.memo pt_memo
         from dcc.callcard c, dcc.vbn b,
            (select c.id id, t.memo tmemo, ct.memo memo, t.idt idt 
            from dcc.callcard c, dcc.call_theme ct, dcc.theme t, dcc.vbn b
            where c.id=ct.id and ct.idt=t.idt and t.memo like 'Тема %' and c.bn=b.cbn 
            and b.bn in (21,22,23,24,25,26) and c.db>=startDate and c.db<=endDate) ss1,
            (select c.id id, t.memo tmemo, ct.memo memo, t.idtp idtp 
            from dcc.callcard c, dcc.call_theme ct, dcc.theme t, dcc.vbn b
            where c.id=ct.id and ct.idt=t.idt and t.memo like 'Подтема %' and c.bn=b.cbn 
            and b.bn in (21,22,23,24,25,26) and c.db>=startDate and c.db<=endDate) ss2
        where c.bn=b.cbn and b.bn in (21,22,23,24,25,26) and c.db>=startDate and c.db<=endDate
        and c.id=ss1.id and c.id=ss2.id and ss1.idt=ss2.idtp) s4
where с.bn=b.cbn(+) and b.bn in (21,22,23,24,25,26) and substr(с.bn,2,10)=m.transfer_nom(+) 
and с.id=s1.id(+) and с.id=s2.id(+) and с.id(+)=s3.id and с.id=s4.id(+) 
order by с.id, s4.t_memo;
 
      RETURN ( mtt_cursor);
end mttIncommingReport1;

 Hibernate:    { ? = call olg.mttincommingreport1(?,?)}
WARN  [org.hibernate.util.JDBCExceptionReporter] (http-127.0.0.1-8080-2) SQL Error: 17041, SQLState: null
ERROR [org.hibernate.util.JDBCExceptionReporter] (http-127.0.0.1-8080-2) В индексе отсутствует параметр IN или OUT:: 3

<named-native-query name="kpiQuery" result-set-mapping="kpiQueryResult">
        <query>
        <![CDATA[
            {call olg.mtt_total_stat(?, :startDate,:endDate,:delta,:grp1,:grp2,:grp3)}
        ]]>
        </query>
        <hint name="org.hibernate.callable" value="true" />
    </named-native-query>
    
    <sql-result-set-mapping name="kpiQueryResult">
    </sql-result-set-mapping>

@PersistenceContext//(type=EXTENDED)
    private EntityManager em;

.......

@SuppressWarnings("unchecked")
        ArrayList<Object[]> resultList = (ArrayList<Object[]>) em.createNamedQuery("kpiQuery")
                .setParameter("startDate", filterStartDate)
                .setParameter("endDate", filterEndDate)   
                .setParameter("delta", delta)
                .setParameter("grp1", selectedGroupList.isEmpty() ? true : selectedGroupList.contains("1")) 
                .setParameter("grp2", selectedGroupList.isEmpty() ? true : selectedGroupList.contains("2")) 
                .setParameter("grp3", selectedGroupList.isEmpty() ? true : selectedGroupList.contains("3")) 
                .getResultList();

@NamedNativeQueries({
@NamedNativeQuery(name = "hourQuery", 
        query = "{call olg.mtt_total_stat_req(?, :startDate,:endDate,:delta,:grp1,:grp2,:grp3)}",
        resultSetMapping="hourQueryResult", 
        hints = { @javax.persistence.QueryHint(name = "org.hibernate.callable", value = "true") }),
@NamedNativeQuery(name = "operatorQuery", 
        query = "{call olg.MTT_OPER_WORK_STAT(?, :startDate,:endDate,:delta,:grp1,:grp2,:grp3)}",
        resultSetMapping="operatorQueryResult", 
        hints = { @javax.persistence.QueryHint(name = "org.hibernate.callable", value = "true") }), 
@NamedNativeQuery(name = "themeQuery", 
        query = "{ ? = call olg.mttincommingreport1(:startDate,:endDate)}",
        resultSetMapping="themeQueryResult", 
        hints = { @javax.persistence.QueryHint(name = "org.hibernate.callable", value = "true") }),
@NamedNativeQuery(name = "dayQuery", 
        query = "{ ? = call olg.mttdayreport(:startDate,:endDate,:grp1,:grp2,:grp3)}",
        resultSetMapping="dayQueryResult", 
        hints = { @javax.persistence.QueryHint(name = "org.hibernate.callable", value = "true") }),
@NamedNativeQuery(name = "operatorNoteQuery", 
        query = "{ ? = call olg.mttoperatornotereport(:startDate,:endDate)}",
        resultSetMapping="operatorNoteQueryResult", 
        hints = { @javax.persistence.QueryHint(name = "org.hibernate.callable", value = "true") }),
@NamedNativeQuery(name = "regionQuery", 
        query = "{ ? = call olg.mttregionreport(:startDate,:endDate,:grp1,:grp2,:grp3)}",
        resultSetMapping="regionQueryResult", 
        hints = { @javax.persistence.QueryHint(name = "org.hibernate.callable", value = "true") }) 
})
@SqlResultSetMappings({
@SqlResultSetMapping(name="hourQueryResult"),
@SqlResultSetMapping(name="operatorQueryResult"),
@SqlResultSetMapping(name="themeQueryResult"),
@SqlResultSetMapping(name="dayQueryResult"),
@SqlResultSetMapping(name="operatorNoteQueryResult"),
@SqlResultSetMapping(name="regionQueryResult")
})

@Entity
@Table(name = "CALLCARD")