i have a procedure as below which returns ref cursor
procedure p1 (empid in number, p_data out sys_refcursor) is
begin
open o_data for select * from emp where emp_id = empid;
---exception handle
/*
how to handle error when there are no records matching the parameter passed
*/
end;