Call PL/SQL function with output cursor parameter

0

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.

mmm.shz87's picture
Joined: Jul 12 2016 - 10:57pm
Last seen: 2 years 6 months ago

1 Answer:

0

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

{CALL DECLARE
 
t NUMBER;
BEGIN
t :=  your_function($P{ORACLE_REF_CURSOR} );
END
}

software_7's picture
Joined: Dec 30 2013 - 7:05am
Last seen: 1 year 7 months ago
Feedback