Help on stored proc

I posted this question recently, but got no help. Here i am again asking for HELP:

I need HELP!! I 'd like to create a stored procedure returning more than 1 row as the resultsets. For example, I would like to create a stored
procedure to return a list of employee names and salaries who were hired

before Oct.1.1996. I tried,

create or replace procedure XXXXXX (hiringdate VARCHAR2) is
begin

   select ename, sal from emp where to_date(hiring_date,'YYYY-MM-DD') < '1996-10-01'
end

It gives some compile error when trying to compile the stored procedure (Error: PLS-00428: an INTO clause is expected in the SELECT statement).

I believe I must use cursor. However, I don't know how to write a stored proc to return cursor . Can somebody give me some help.

I tried something like
create or replace function XXXXX (hiringDate VARCHAR2) return c1%ROWTYPE

IS
cursor c1 is select ename, sal from emp where to_date(hiringDate, 'YYYY-MM-DD') < '1996-10-01'
begin

    open c1;
     return c1;
end;

It gives me compiler error.

Many many thanks in advance. Received on Sun Jun 07 1998 - 21:05:35 CDT