Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Proc Question (rows returned)?
A copy of this was sent to Joe M. <joemart_at_my-deja.com>
(if that email address didn't require changing)
On Thu, 06 Jan 2000 18:20:39 GMT, you wrote:
>I think this is a simple question, I want to write a stored procedure
>that will take a pramater and return result rows. As an example,
>gieven a department number I want to return a list (rows) for all
>employees in that department. I know how to do this in Sybase or MS
>SQL but I haven't seen an exapmle anywhere in PL/SQL. All the exapmles
>of procs (or functions) I see in PL/SQL only insert a row into a table,
>never return multiple rows.
>
see http://osi.oracle.com/~tkyte/ResultSets/index.html
>My motivation for this is to replace a bunch of ad hoc queries with
>stored procedures. I hope that by doing this I can better manage what
>is going in/out of the shared pool (~ procedure cache in Sybase?). My
>concern is that in the system I am newly admining there are a lot of
>users using ad hoc queries and I'm not sure the execution plans are
>being reused. Interesting article at www.oreview.com/9701snow.htm.
>
>Thanks,
>Joe
>Yes, I am new to oracle.
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jan 06 2000 - 13:04:09 CST
![]() |
![]() |