stored proc with resultset not linked to a table

Here's my probleme :

I need a proc to aggregate data from various table and processing, and I expect it to return a resultset, designed to be called from JDBC.

How could I do this ?

using a REFCURSOR ?
but it is not based on a select, so ?

using array ?
how do I do this ?

Thanks for any clue.

NB: I'd like not to use an temp table if possible ..... Received on Tue Feb 05 2002 - 03:32:23 CST