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