Re: Returning Rows from a Stored Procedure in Oracle...can it be done?

Reference Cursors do this. there are samples on powersoft's web site of doing this. If you can't find them, email me, and I'll send you some.

On Tue, 27 Oct 1998 18:16:25 GMT, "Ryan Gallagher" <ryang_at_quadrus.com> wrote:

>In MS SQL server, I am able to have a store procedure that returns a result
>set and use it Via ADO recordset. How do I do this in Oracle?
>
>Sample SQL server Code....
>=======================
>(For those of you who don't know MSSQL the last SQL Select statement in a
>SQL statement will be returned as a dataset to ODBC)
>
>CREATE PROCEDURE spGetUsers(@UID INTEGER)
>BEGIN
>
> /* Heres some sort of condition statement*/
>
> IF @UID > 10
> BEGIN
>
> /*Return Users with UID < 10*/
> SELECT UID,UserName FROM tblUser WHERE UID < @UID
>
> END
> ELSE
> BEGIN
>
> /*Return Users with UID > 10*/
> SELECT UID,UserName FROM tblUser WHERE UID > @UID
>
> END
>
>END
>
>
>Sample ADO Code (in VB5)....
>===========================
>
> Dim dbCon As New ADODB.Connection
> Dim RS As New ADODB.Recordset
>
> 'connect to the database
> dbCon.Open "DSN=MyDB", "sa", ""
>
> 'Execute the SQL Statement
> RS.Open "EXEC spGetUsers 23", dbCon, adOpenForwardOnly
>
> *This should fill the RS with the records returned by spGetUsers*
>
>
>Any help would be appreciated
>(If possible, please Cc: me by email)
>
>Thanks
>Ryan Gallagher
>
>
>
Received on Fri Oct 30 1998 - 12:33:48 CST