I have a function in my PL/SQL package of Oracle database that has a parameter as out parameter and with "SYS_REFCURSOR" type. Indeed, the result of the query is saved in the out parameter. Now, I do not know how to call function in jasper and use the result of it wich can access as out parameter with type of "SYS_REFCURSOR". Could you please help me to solve this problem?
The declaration of function is
FUNCTION Function_Name(O_CURSOR OUT SYS_REFCURSOR) RETURN Return_Type;
Also I use Jaspersoft Studio 6.3.1.
Thanks a lot for your time in advance.