Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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:
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.orgReceived on Sat Jan 06 2007 - 15:27:12 CST