RE: Can you return a result set from a stored procedure?

From: Berger, Gene <BERGERGENE_at_PIOS.com>
Date: Thu, 3 Feb 2000 12:38:21 -0500
Message-ID: <07E164D341EED111ADCD0000F8662F4A086CA7A5@pioushqntmail2.pios.com>

There is a great FAQ at www.learnasp.com that has this in-depth. Just do a search on "Oracle".

-----Original Message-----
From: dave mausner [mailto:dmausner_at_ameritech.x.net] Sent: Wednesday, January 26, 2000 9:51 PM To: comp.databases.oracle.server_at_list.deja.com Subject: Re: Can you return a result set from a stored procedure?

 Message from the Deja.com forum:
 comp.databases.oracle.server
 Your subscription is set to individual email delivery

john_at_snapjax.com (John Hamm) wrote in <86num4$ela$1_at_news.gate.net>:
>create procedure test
>...
> select * from patients

yes you can do that in sybase and sql-server (yawn) but this is oracle so it is different. look into refcursors which allow a proc to open a cursor and then pass it back to the calling program for use. you will not need to restrict the cursor to 25 rows; the program can fetch from the cursor until it is out of data.
--
dave mausner

---

 Deja.com: Before you buy.
 http://www.deja.com/

• To modify or remove your subscription, go to http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
• Read this thread at http://www.deja.com/thread/%3C8EC7D02EEdlm%40206.141.192.241%3E

 Sent via Deja.com http://www.deja.com/  Before you buy. Received on Thu Feb 03 2000 - 11:38:21 CST