Call PL/SQL function with output cursor parameter

[mmm.shz87]

Hi all,

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.

[bayfarm]

Just choose plsql as your language and put in something like:

{call declaret number;begint :=  your_function($P{ORACLE_REF_CURSOR} );end}[/code]