Create Stored Procedure to Return Recordset?

From: SR <shawnjulie007_at_hotmail.com>
Date: Fri, 22 Jun 2001 15:22:59 -0400
Message-ID: <PYMY6.252347$Z2.2971273@nnrp1.uunet.ca>

I'm attempting to migrate a simple database from SQL Server to Oracle 8.1.7.

I'm attempting to create a simple Stored Procedure that returns a recordset to a Visual Basic Program via ADO. The VB side of things is no problem. I'm having difficulties with the syntax for the stored procedure in Oracle.

How do you create an Oracle Stored Procedure that returns a set of records?

ie. Stored Procedure that accepts a parameter and runs a SQL statement and returns the results?
(select * from table1 where field1=InputParameter) Received on Fri Jun 22 2001 - 14:22:59 CDT