how to call a plsql procedure to fill temp tables before the report starts the query

[ahackmann]

we are trying to migrate from Oracle Report Server to Jasper Reports.
The existing reports are based on global temporary tables that are filled by a plsql procedure before the report can query these tables.

My approach in JasperReports was to create a Scriptlet and overwrite the beforeReportInit() to call the plsql procedure from here. 
That worked so far, but unfortionally the report query is executet before the plsql proedure is called, so the tables are empty at this point.

Has anyone solved this very common approach in Jasper Reports? I would be gratefule for any advice.

best regards
Arne

[jgust]

You could have the stored procedure populate the temp table and return a cursor.