Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to make Stored Proc return recordset?

Re: How to make Stored Proc return recordset?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/20
Message-ID: <964121694.4806.0.pluto.d4ee154e@news.demon.nl>#1/1

<allasrosa_at_my-deja.com> wrote in message news:8l7bo9$tsn$1_at_nnrp1.deja.com...
> Hi there,
>
> I'm handling a case in which i want a stored proc
> to return a recordset. Oralce version is 7.3...
> Look around but just find out no clue. Can anyone
> here give me some suggestions? Otherwise I may
> need to create a table for temp storage.
>
> All input are welcome. :) Thanx in advanced.
>
> Cheers,
> Allas
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

I answered exactly the same question yesterday, so this is getting a bit boring (and the Deja archives definitely underuser) Either refer to your pl/sql documentation under REF CURSOR or the same topic in Steven Feuersteins Pl/SQL book or http://osi.oracle.com/~tkyte

As this question is getting a bit boring, this the last time I answer it.

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Jul 20 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US