Re: pl/sql ref cursor question

ajoshi997_at_yahoo.com wrote:

> Hi,
> I currently have a oracle pl/sql procedure which returns a ref
> cursor returning a record (empid, empname, salary) for a condition.
> Data has changed so that now multipe rows can satisfy the condition.
> How do I change the procedure to return multiple rows maybe use an
> array. Will it work? Any onw with experience with it?
>
> Thank You

No need to change anything. A REF CURSOR, by definition, returns multiple rows.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)