Returning Result set

CREATE OR REPLACE PROCEDURE scott.proc (v_deptno nmuber,p_result_set OUT sys_refcursor)
IS
BEGINOPEN p_result_set FOR
SELECT *FROM emp
END;WHERE deptno LIKE '%' || v_deptno;