Re: Can a stored procedure or function return a recordset

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