Re: stored proc with resultset not linked to a table

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 05 Feb 2002 14:13:23 GMT
Message-ID: <7MR78.25274$ym3.83238@rwcrnsc51.ops.asp.att.net>

http://asktom.oracle.com/pls/ask/f?p=4950:8:475337::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:246014735810,%7Btable%7D%20and%20%7Bplsql%7D

the ask tom site is very useful.
http://asktom.oracle.com/pls/ask/f?p=4950:1: Jim

"Philippe Marsollier" <philippe.marsollier_at_sncf.fr> wrote in message news:a3o8pa$in5$1_at_muguet.sncf.fr...
> 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 - 08:13:23 CST