PROCEDURE sp_rank(p_cursorVar out CursorType) 
is
begin 
	open  p_cursorVar for
	select emp_id, emp_name from emp;

End sp_rank;