JasperSoft Studio - Populate Temporary Table With Stored Procedure Before Report

[alexandre.massy]

Hi,

I'm trying to populate a global temporary table with a stored procedure (Oracle) before reporting in JasperSoft Studio so I can have some subreports using that filled temp table.

This stored procedure looks like this :

CREATE OR REPLACE PROCEDURE EXEC_TMPTABLE (pdate IN DATE) AS 

 

BEGIN

 

    package.init_tmptable;

    package.procedure1(pdate):

    package.procedure2(pdate);

    package.procedure3(pdate);

   commit;

 

END;

I tried to put some pl/sql to call this stored procedure : {call EXEC_TMPTABLE($P{DATE}) }

After the call, I'll have to call several subreports that will use the previously filled temp table. Unfortunatly, I keep having a blank document and nothing comes out.

Does anyone have an idea ?