Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql ref cursor question

Re: pl/sql ref cursor question

From: <ajoshi997_at_yahoo.com>
Date: 8 Jan 2004 09:22:40 -0800
Message-ID: <58477c1c.0401080922.20cdd927@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US