Regard use STORE PROCEDURE as Data set
I need to use STORE PROCEDURE as Data set, and there is one out parameter which is cursor.
The definition of it is like this:
PROCEDURE PROC_INVAGING_JW (pcomany varchar2,enddate varchar2,p_rc OUT myrctype) ;
So I use it as the data set like this:
DECLARE
xdo_cursor TESTTBMOVEMENT.myrctype;
BEGIN
TESTTBMOVEMENT.PROC_INVAGING_JW('06060','2018-10-31',:xdo_cursor);
END;
and there is no data at all.
Who can help to confirm the way to use STORE PROCEDURE on BI Publisher system?
Thank you!