Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql ref cursor question
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1073531770.976679_at_yasure>...
> 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.
Thank you Daniel. :-) Received on Thu Jan 08 2004 - 11:22:40 CST