Re: Can a stored procedure or function return a recordset

Sorry that doesn't work

<tigsar_at_my-deja.com> wrote in message news:8kn6rg$cmg$1_at_nnrp1.deja.com...
> You can use a "cursor"
>
> Sample
>
> Create function ttt return cursor is
> cursor cc is select sysdate from dual;
> begin
> return cc;
> end;
>
> In article <8klhei$gkj$1_at_acs2.byu.edu>,
> "Jake Anderson" <jakeanderson_at_byu.edu> wrote:
> > I know this is a dumb question but I am kind of new at oracle. I am
 almost
> > certain that it is possible but I can't seem to do it.
> > How would I get a function or procedure to return a recordset. I just
 want
> > it to return the results of a select query. But I can't use a view
 because
> > it has parameters. Unless you can do parameters in a view. Which I
 also
> > wouldn't know how to do. Thanks for the help.
> >
> > --
> > Jake Anderson
> > jakeanderson_at_byu.edu
> > MTC Development
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 14 2000 - 00:00:00 CDT