Returning a result set from procedure

Hi,
I work with Oracle 7.1 Server.
Can I create procedure or function or smth returning a result set? I know I could manage it with MSSQL
It would be

CREATE PROCEDURE MY_PROC @PAR1 VARCHAR(10) AS
SELECT * FROM MY_TABLE
WHERE MY_TABLE.NAME = @PAR1 View or snapshot would hardly suit because the result set depends on parameters very complexly.
Thank You. Received on Tue Aug 25 1998 - 07:24:22 CDT