[SOLVED] PROBLEM WITH ORACLE GLOBAL TEMPORARY TABLE

[cyberdemos]

Hi all,
i've a big and urgent problem!

I've to call an Oracle  stored procedure from Jasper and i've followed the interesting guide here: http://www.brianburridge.com/2006/06/04/how-to-call-stored-procedures-from-jasper-reports/

A function calls a stored procedure and then returns data to jasper.

The problem is that this stored procedure writes output into a oracle global temporary table and so when the procedure ends all data are lost because of  "delete on commit" option.

When i go to read data thru a cursor from GTT no data are found...

So... is there any way to move the reading of GTT inside of Stored procedure before its commit with all data inside temporary table?

Thanks a lot this is a very big problem... 

[sOLVED]

The solution for me was writing the stored procedure directly inside the function writing its output  inside the created type created instead inside temporary table.

So the ORACLE temporary table is not used, the table of types is very performing and there are no problems with session as with temporary tables.

Bye! 

Post Edited by cyberdemos at 01/27/2011 15:31