Need example of Stored Procedure that returns a resultset

Hello everyone,

Could someone show me an example of how to create a stored procedure that returns a resultset? I would like to have my Access application call a SQL- Passthrough query so that it returns list of rows. I am able to create a stored procedure in SQL Server but cannot figure out how to do it in Oracle (even after browsing the newsgroups and reading Oracle documentation).

For example, I can create a stored procedure in SQL Server with the following code:

CREATE PROCEDURE spTest(@some_var int)
AS

     SELECT * FROM someTable WHERE amt = @some_var go

How do I do this in Oracle? Please show an example of how this procedure would like in Oracle. Thank you.

--David Kochan

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 05 1999 - 09:38:10 CST