Re: Stored Procs Returning Multiple Records

jay2dedios_at_hotmail.com wrote:
> Hi,
> I'm interested in using stored procedures to return multiple rows in my
> ORACLE DB. Are there any issues (performance, for example) with doing
> so? It seems as if this is not a popular method.
> Is there a best practice?
> Please help. Thanks!

Lets see what missing from your post:

1. Oracle version
2. Technology intended to return multiple rows
3. Where you got the idea it wasn't popular.

Look up REF CURSOR. That is essentially the only purpose they serve. http://www.psoug.org/reference/ref_cursors.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org