Re: How to create Stored Procedure to return rows

Another note: If you're using VB, you need to have ADO 2.5 installed to use Oracle Ref Cursors. They don't work with the earlier versions of ADO.

Mani Visweswaran

"Tim McCoy" <mccoy2000_at_earthlink.net> wrote in message news:3AC5E4C1.F0700642_at_earthlink.net...
> Bill wrote:
> >
> > Dear All,
> >
> > I'm a newbie in Oracle and want to create a stored procedure to return
 rows
> > just as "Select * from equipment".
> >
> > Could anyone kindly give me the sample script or for it?
> >
> > Do I need to use PL/SQL and PACKAGE?
> >
> > Regards,
> >
> > Bill
> > kwlau_at_writeme.com
>
> The other posts are helpful unless you are trying to return rows to a M$
> client through ODBC. To do that you should use a M$ recordset and a SQL
> PASSTHROUGH query defined on the client side. I get this question a lot
> from VB programmers coming out of a SQL Server shop where you can write
> a query as a stored procedure and have it return the rows through a
> recordset to their VB client through ODBC.
Received on Mon Apr 02 2001 - 07:07:01 CDT