Getting recordset from stored procedure

I am a seasoned SQL Server stored procedure programmer. But in Oracle, is there a way to return record sets from a stored procedure? I wish to do something like this:

create procedure get_data
as
begin
  select * from emp;
end;
/

Please help, thanks. Received on Tue May 26 1998 - 21:38:27 CDT