Re: procedure returning 2 rows

dazed_confused_lost wrote:
> I am stuck. Yes I have read the documentation. I was not able to
> memorize it though. I have searched google, asktom, oracle.com and my
> bookshelf of books on Oreilly safari and many google group posts. I am
> still stuck.
>
> Could someone kindly post a Oracle 9i PL/SQL example that simply
> SELECTs 2 rows from a table and then displays those rows? Also please
> include the syntax needed to call the procedure and display those 2
> damn rows.
>
> I will run it in toad or sqlplus.
>
> A complete full example would include 2 more things.
> create table statement (separate from procedure)
> insert statement (inserting 2 rows) (also separate from procedure)
>
> I need a full working example, not a link to a another website.

www.psoug.org
click on Morgan's Library
click on REF CURSOR
Run the demo for weakly typed
as the first input parameter to the Child proc use the number 2.

It is one solution among many.

-- 
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