hi chandu,
this is a sample one

create or replace procedure proc_name(proc_cur in out 
sys_refcursor)
as
begin
open proc_cur for select * from tab;
end;