Re: Returning Resultsets from Procedures?

Thanks for the info. I am returning a result set similar to this and would like to know the syntax for executing this stored procedure from and ASP page. I am using ADO to connect to the database. help?

In article <37AF4C41.9ADE2669_at_Boeing.com>,   Martin Douglas <Martin.Douglas_at_Boeing.com> wrote:
> I use something like... (off the top of my head here...)
>
> create or replace package types as
>
> ref_cur_t is ref cursor;
>
> end types;
> /
>
> create or replace procedure get_hangout_locations(p_place in varchar2,
> p_locations in out types.ref_cur_t)
> as
> begin
> open p_locations for
> select address from late_nite_bars
> where area = p_place
> and has_happy_hour = 'Yes';
> end get_hangout_locations;
> /
>
> I use OO4O to retrieve the cursor from the server to the client.
>
> Best of luck... and cheers.
>
> me_at_nospam.com wrote:
> >
> > Can Oracle stored procedures return result sets? What I mean is
> > can I do something like:
> >
> > create procedure getthem (tablname in varchar2)
> > is begin
> > select * from tablname;
> > end;
> >
> > If yes how?
> >
> > TIA
> > Selcuk
> >
> > --
> >
> > Selcuk Ozturk --- sozturk at fdch dot com
> >
> > My views are mine alone.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 03 1999 - 09:40:36 CDT