Is there any way to handle refcursor from stored procedures in Hibernate? I'm facing Oracle Dialect problem.
create or replace package pck_test is


-- Public type declarations
procedure proc_return(in_param number,
out_list1 out sys_refcursor,
out_list2 out sys_refcursor
);

end pck_test;
/
create or replace package body pck_test is

procedure proc_return(in_param number,
out_list1 out sys_refcursor,
out_list2 out sys_refcursor
)
is
begin
open out_list1
for
select 1,2 from dual;

open out_list2
for
select 3,4 from dual;
end ;

end pck_test;