HELP! ORACLE Stored Procedures and multiple rows

Hi.

I'm trying to get Oracle stored procedures to return datasets. I'd like to do something like

CREATE OR REPLACE PROCEDURE FOO ( BLAH ) BEGIN
  SELECT * FROM TABLE WHERE COLUMN = VALUE; END; Where it returns a bunch of rows. How is this done?

Thanks!

Cheers,
--Norm Received on Thu Jun 04 1998 - 22:11:20 CDT